Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

query slowdown

 
Robert Boyle
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 231
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!