This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes query slowdown Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "query slowdown" Watch "query slowdown" New topic

query slowdown

Robert Boyle

Joined: Sep 28, 2005
Posts: 3
hi there wondering if anyone can shed any light on this prob i am having:

java 1.4
oracle 10.2
weblogic 9.1

have a query running sub second on sqlplus and through a test class i generated to use jdbc. however in the application it is taking 20secs and is taking this time once accessing the jdbc method ps.executeQuery(). Other queries (the same query without a predicate being added) runs sub second on the app so i am mighty confused.

Anyone? thanks in advance.

Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231

Check if the predicate is doing some costly operations on charater field. We can help you more if you can post both the queries.

I agree. Here's the link:
subject: query slowdown
It's not a secret anymore!