Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ResultSet is too slow. How can one make it faster?

843854Jul 9 2003 — edited Jul 10 2003
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2003
Added on Jul 9 2003
21 comments
3,346 views