• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Slow SQL slowing application - how to speed things up?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


  • Follow-Ups:
    • Re: Slow SQL slowing application - how to speed things up?
      • From: Chuck Hill <email@hidden>
    • Re: Slow SQL slowing application - how to speed things up?
      • From: Q <email@hidden>
  • Prev by Date: Re: App Engine supports Java
  • Next by Date: Re: Slow SQL slowing application - how to speed things up?
  • Previous by thread: Re: AjaxObserveField causing blinking in update
  • Next by thread: Re: Slow SQL slowing application - how to speed things up?
  • Index(es):
    • Date
    • Thread