File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC application Performance mystry Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC application Performance mystry" Watch "JDBC application Performance mystry" New topic
Author

JDBC application Performance mystry

kundi kx
Greenhorn

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: http://aspose.com/file-tools
 
subject: JDBC application Performance mystry