Slow SQL slowing application - how to speed things up?
Slow SQL slowing application - how to speed things up?
- Subject: Slow SQL slowing application - how to speed things up?
- From: Peter Newnam <email@hidden>
- Date: Thu, 9 Apr 2009 08:40:28 +1000
Hi All
We have some slow SQL (40 instances of code in an 8 hour period taking
between 5 and 10 seconds to run). Obviously the SQL needs to be
tuned, indexes need to be added etc. The result is that pages start
timing out when user numbers increase ( > 30 users on a single Tomcat
machine running Project Wonder with WO5.4). It appears that the
database connection becomes the bottle neck and is responsible for
slowing things down. At the moment each page access writes to the
database as a page access log - so the connection is heavy used for
updates/inserts. So ..... what do you thing the best practice would
be to improve performance?
My initial thoughts would be to tune the SQL, check/correct abuse of
loading large datasets and add additional database connections as it
appears to only use one regardless of the load (however I noticed
another connection open on the server that seems to be WO internal
workings - it gets information on data types etc.). However based on
this thread - http://lists.apple.com/archives/webobjects-dev/2005/Jul/msg00501.html
it appears that multiple database connections don't work as
expected. Would it help though?
It seems a bit overkill to start clustering Tomcat instances for less
than 100 users - any ideas on the best way to improve performance?
The performance appears to have gotten worse with WO5.4. Is that
possible?
Thanks
Peter
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden