Slow Performance with O8 and D4

[iolani]

a) How could it be, that a locate.event in 4000-entries Oracle8-Table causes a delay of up to 30 seconds. QueryAllRecords is set to false already. What about the Readbuffer-property? What are recommended values for that?
The SQL-Explorer works in fine speed.
b) TOracleDatasets linked to another TOracleDataset by Master/Detail-Fieldlink require large amount of time to get updated. Same as above.

We use Delphi 4 with Update Pack 2 and DAO 3.3.1.
Can anybody tell me, what to do?

Thanks for replies
Knut Reckweg

 

[Helene]

You should try to limit the number of records returned by the SQL statement instead of using Locate. Locate works on the client, and if the record you are locating is the last one in your dataset you have to fetch all 4000 records before it is found. That happens regardless of the value of the QueryAllRecords property.

------------------

 

[iolani]

It worked quite well, thanks.
Now I'm trying to get last bit of speedup by tuning Oracle.