This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes query slowdown Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "query slowdown" Watch "query slowdown" New topic
Author

query slowdown

Robert Boyle
Greenhorn

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

environment:
java 1.4
ojdbc 10.2.0.2
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.

R.
Sivaraman Lakshmanan
Ranch Hand

Joined: Aug 02, 2003
Posts: 231
Hi,

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

Regards,
Sivaraman.L
 
GeeCON Prague 2014
 
subject: query slowdown