Sorting records has an impact on performance.
Keep the following factors in mind when attempting to assess the performance impact of the sorting feature:
Record sorting is a cached feature. That means that each dimension or property enabled for sorting increases the size of the dgraph process. The specific size of the increase is related to the number of records included in the data set. Therefore, only dimensions or properties that are specifically needed by an application for sorting should be configured as such. Sorting gets slower as paging gets deeper.
In cases where the precomputed sort is rarely or never used (such as when the number of search results is typically small), the memory can be saved.