bulk operations

C

cosmini

Member²
hello Marco,
is there any way to retrive records from a database faster (other than setting the ReadBuffer to a higher value), like using bulk selects etc (through TOracleQuery) ? I need to retrieve a large number of records (for an optimized query whose' cost is '4') and the best I can do is roughly 100k/min.

thx,
Cosmin
 
The ReadBuffer is the only Direct Oracle Access property to improve this. Setting it higher will reduce the number of network roundtrips and increase the memory usage.

To speed things up further you can tune the database tables (add indexes, add redundant columns, ...), or the query (e.g. remove unnecessary columns).

The Oracle Monitor Pro allows you to find out exactly what the bottlenecks in your query are: Client, Server, or Network.

------------------
Marco Kalter
Allround Automations
 
You must log in or register to reply here.
Back
Top