Specifies whether the provider performs ORDER BY operations server-side.

Data Type

bool

Default Value

true

Remarks

This property determines whether the provider pushes down sorting (ORDER BY clause) to the SugarCRM API or handles ordering on the client.

When set to true (the default), ordering is performed by SugarCRM. Having or creating indexes results in the best query performance. For more information, refer to the SugarCRM Indexes Documentation.

When set to false, the provider requests the data from SugarCRM and handles sorting on the client.