Locate & LocateEx speed

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Margo
Posts: 4
Joined: Thu 22 Mar 2007 10:33

Locate & LocateEx speed

Post by Margo » Tue 10 Apr 2007 14:04

What is the difference in find speed between Locate and LocateEx methods? How can I increase it whithout FilterSQL property use?

Thanks

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 11 Apr 2007 08:58

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.

Post Reply