File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC application Performance mystry Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC application Performance mystry" Watch "JDBC application Performance mystry" New topic

JDBC application Performance mystry

kundi kx

Joined: Feb 03, 2003
Posts: 10
I programmed a Java application that read from data files and update Database through JDBC-ODBC.
Normally it was quite slow, 200 insert/delete takes about 50 seconds. Might have been low resource on my system. But no matter if I close all other application, it still run roughly 50 second, +/- 5 sec.
I didn't close the application and left over-night. Now I run the same 200 insert/delete testing operation set again, 2 seconds! repeatedly 2 second. What is going on?!?!
I agree. Here's the link:
subject: JDBC application Performance mystry
It's not a secret anymore!