File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: query slowdown