my dog learned polymorphism*
The moose likes JDBC and the fly likes sql query taking more time from java code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql query taking more time from java code" Watch "sql query taking more time from java code" New topic
Author

sql query taking more time from java code

lusha tak
Ranch Hand

Joined: Dec 30, 2000
Posts: 185
I have written a nested query. when i run this query using prepared statement, type 4 driver it takes alomst 15 minutes to run from java code whereas it takes only a second when run directly on sqlserver query analyzer. it is just this query in java code that is taking so much time. No problem at all with any other query in the same piece of code
what can be the reason ?

any ideas?
thanks
Lusha
seby mathew
Greenhorn

Joined: Apr 19, 2006
Posts: 7
can u upload the code, are you sure it is the qry execution consume time not the data manipulation after execution of the qry ?
 
jQuery in Action, 2nd edition
 
subject: sql query taking more time from java code
 
Similar Threads
"select.." in jdbc gives bad performance but not in mysql directly
URGENT --Help needed --- Delay in executing SQL Query..
Whacky db problem.
preparedStatement.executeQuery() not returning , not even showing any error
EJB Hibernate Persistence