• Post Reply Bookmark Topic Watch Topic
  • New Topic

query hangs in app server, not dbvisualizer

 
doug parker
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have a query that takes an extremely long time to execute in my app server yet i do not have this problem when i execute it inside dbvisualizer (a jdbc db client). what could explain the difference?

i notice this behavior only when i return a large number of rows, ~32k. if i supply parameters that would return a small number, both dbvisualizer & the app server return in roughly the same amt of time. also note that the app server is hanging on the prepared statement's execute() method.
[ August 22, 2005: Message edited by: doug parker ]
 
Annie Smith
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm just trying to guess the reason... I think it might have something to do with the memory available to the VM.
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36032
432
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Doug,
Network traffic is one of the most common reasons for this. You can verify this by just returning one field in the select statement.

To actually solve the problem, check if you are returning any unneeded data. If all the data is really needed, you will need to look into network improvements.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
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!