I use the TDataSet.Locate Method to search the specific record, but when the table is large, then the searching speed is slow.
how to improve that? Or there are other way to do the fast locate record in a table??
thx..
Akira
how to imrove the locate record speed in delphi?
ODAC cannot use indexes that are created on the server for locating record on client. In any case, operation of locating record on client side needs all records to be present. You can increase performance if you choose another methods. Try to organize filtering on server side using FilterSQL property or including WHERE clause to the SQL statement.