JDBC performance with large result set from Oracle DB
843859Oct 20 2005 — edited Mar 23 2006Hello,
I am trying to retrieve a large result set, typically about 40K records, form oracle database. This query is run daily once. I am using JDBC.Can anyone know if setting the fetchsize() on the Statement object improves the performance???. I am using oracle thin driver.
If yes, what would be the optimum fetch size for the problem mentioned above?. Also i read something which suggests to stick with the default fetch size set for the driver being used.
http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/resultset.html.(section 6.1.10 Providing Performance Hints)
But i also found an article which contradicts the above.
http://jdj.sys-con.com/read/46653.htm.
If any one has run into similar issue, kinldy guide me in this regard.
Thanks in advance,
ashton