• 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
Marshal
Posts: 35279
384
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic