Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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 The Software Craftsman this week in the Agile forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?!?!
 
Have you tried LearnNowOnline? http://www.learnnowonline.com/
 
subject: JDBC application Performance mystry