Performance and scalability: Does "Bulk Collect" feature of Oracle Help?
- Posted by: Val
- Posted on: September 21 2004 14:34 EDT
Has anyone used the "Bulk Collect" feature?
We have an Oracle 8i database, and a lot of data to be queried and shown in reports. The current performance is very slow. Would doing a bulk collect help? Any tips??
But how are you accessing the data - SQL*Net, JDBC, ODBC?
In any case you shoudl always look at doing an array fetch reather than single row fetches, that will make a huge difference to preformance
You can reduce the round trips to database by customizing the prefetch size.
This is available in Oracle JDBC driver version 9.0.x