ResultSet is too slow. How can one make it faster?
843854Jul 9 2003 — edited Jul 10 2003Hi all,
I've made a database request with 5 joins and got a ResultSet of 500 000 rows.
My computer needs approximately 106 sec just to go through the ResultSet.
(A simple loop with 500 000 repeats needs 10 millisec).
The only sollution I've found is to load all tables separately and make the
joins in the application. This looks ugly but needs 10 sec only.
What would you recommend me?
Did anyone have the same problem?
Thank you in advance.