Hi Brian,
Another thought on the quick-fix list - what are your JVM memory settings? I find I have to at least set something like "-Xms128m -Xmx128m" or I'll grind to a halt in no time. Much more if I'm using extensive in-memory caching. It's worth checking the tomcat/manager/status for memory usage while it's running exhibiting the problem.
Cheers, Kris
Brian Barnett wrote:
We execute a query through the web app that takes 55 seconds to complete. While this query is executing, we execute another query against the same table in a different browser. It normally takes a few seconds, but it will not complete until the first one does.
If we do the same thing in two instances of TOAD (sql query tool), the second query returns immediately.
Can someone shed some light on what is going on, where to look, etc.?
Thanks, Brian Barnett
-- Kris Jenkins Email: [EMAIL PROTECTED] Blog: http://cafe.jenkster.com/ Wiki: http://wiki.jenkster.com/
