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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: http://aspose.com/file-tools
subject: JDBC application Performance mystry
Similar Threads
JDBC start/stop database needed
Page Loading time in struts
Save information in SQL database using timer
Performance while inserting in DB
Remote JDBC connection performance question