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 Slow execute stored procedure / .prepareCall Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Slow execute stored procedure / .prepareCall" Watch "Slow execute stored procedure / .prepareCall" New topic

Slow execute stored procedure / .prepareCall

Miran Cvenkel
Ranch Hand

Joined: Nov 23, 2010
Posts: 157
See comments, how to avoid 700 ms in process ?
Also the 300 ms should be like 1/2 or less of 300, testing with HeidiSQL
Connection is opened and does not influence a thing.

Searchable nature photo gallery:
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740

If you're asking how to improve JDBC driver methods, the short answer is you can't. You can try other drivers or databases, but likely this is a database specific issue.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Slow execute stored procedure / .prepareCall