Database backing store - gravbox/Gravitybox.Datastore GitHub Wiki

The underlying system is based on SQL server. Each defined repository is mapped to a unique set of SQL tables completely managed by the system. Every field is indexed to anticipate filtering by any field. Individual indexes can be controlled by the object definition by turning off this functionality if the designer determines that it will not be used. In addition to standard indexes, string fields can also be added to the keyword index. A field marked as “AllowTextSearch” wil be added to the SQL full text search functionality. This allows the generic Keyword functionality to filter results based on a text search without specifying the specific field. If filtering on a specific field is required, much better performance will be accomplished by using the FieldFilter functionality.