This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

sql query taking more time from java code

 
lusha tak
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
can u upload the code, are you sure it is the qry execution consume time not the data manipulation after execution of the qry ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic