What is the difference in find speed between Locate and LocateEx methods? How can I increase it whithout FilterSQL property use?
Thanks
Locate & LocateEx speed
There is no difference in speed between the Locate and LocateEx methods if you call these methods with the same options.
The Locate and LocateEx methods work faster when the dataset is locally sorted by the fields that are used for locating. The local dataset sorting can be set by the IndexFieldNames property.
The Locate and LocateEx methods work faster when the dataset is locally sorted by the fields that are used for locating. The local dataset sorting can be set by the IndexFieldNames property.