Brightspot CMS Developer Guide

Solr database

Solr is used as a full-text search database, often supplementing an SQL database in a typical Brightspot application. Containing the same data that is stored in the SQL database, Solr provides the superior text matching capabilities and compound-predicate query performance. However, SQL databases provide faster primary key lookups than Solr, and support atomic updates that were unavailable in Solr until the 4.0 version.

As a best practice, it is recommended that you use an SQL database and a Solr database concurrently via AggregateDatabase. For more information, see Database configuration.

See also:

Previous Topic
SQL databases
Next Topic
Aggregate database
Was this topic helpful?
Thanks for your feedback.
The elements that get you up and running in a matter of days, from pre-built content types, to modules, to landing pages.

Content types
Landing pages
Everything you need to manage and administer content within Brightspot CMS, including plug-and-play integrations.

Admin configurations
A guide for installing, supporting and administering code on the Brightspot platform, including integrations requiring developer support to use.

Field types
Content modeling
Rich-text elements