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!

JDBC Performance with Java

843854Aug 6 2002 — edited Aug 13 2002
Folks,

I am running a financial system which uses the following data in picklists:

1. Categories
2. Payees
3. Orders

For each of these I run a query to get the relevant data from the DB. I am using just Sun JDBC with Microsoft Access. I have done some performance analysis and these are my results.

-> To execute
 rs = statement.executeQuery(sqlQuery); 
Takes 700 milli seconds

-> To place the retreive the results from the result set
Takes a further 600 milli seconds.

For Categories I only have 20-30 entries in the table, and this is not
much different for other tables (i.e. Payees, Order etc).

As they all run sequentially, this takes surprisingly long time to retrieve a small quantity of data.

ANY IDEAS OF HOW TO IMPROVE PERFORMANCE.

Thanks


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2002
Added on Aug 6 2002
26 comments
754 views