TOraTable.Locate Method no use the table index to search?

akiraiu · Post by **akiraiu** » Thu 18 Nov 2004 02:09

Paul · Post by **Paul** » Tue 23 Nov 2004 07:52

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.