Performance - gravbox/Gravitybox.Datastore GitHub Wiki

For very large repositories, each performance can be an issue. Each repository has a default scheme for organizing data; however this can be overridden based on the search pattern of a specific data set. In the object definition, the “IsDataGrouping” property can be set to true to tell the system to create a clustered index on that field. If data will always be select in whole or part on a field, that field can be used as a SQL grouping key such that data is is clustered together on disk for faster access.