• 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
Re: Slow SQL slowing application - how to speed things up?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Slow SQL slowing application - how to speed things up?


  • Subject: Re: Slow SQL slowing application - how to speed things up?
  • From: Peter Newnam <email@hidden>
  • Date: Thu, 9 Apr 2009 12:33:23 +1000


On 09/04/2009, at 11:14 AM, Guido Neitzer wrote:

On 8. Apr. 2009, at 17:04 , Chuck Hill wrote:

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?

First, I'd avoid an insert/update per RR loop just for an access log. Write it out to disk instead. Or at least queue up a message for another thread to use JDBC to write this out.

Good point and something I would like to try.



In the past I've done the same, writing to PostgreSQL and FrontBase databases for logging those things, and I have to say, it is convenient, but performance, especially with FrontBase got an issue when we hit a couple of million rows. The inserts got slower and slower and brought performance down. FrontBase is not really fast inserting into tables when there are a couple indexes on that table - which we had. Dropping those indexes helped, but overall, performance was bad. PostgreSQL didn't show this behaviour, inserts were always fast.

Nevertheless I agree to go the logging to a file route - either with a
specific log4j appender for those messages, or, if it has to be in the
database, maybe with a log4j jdbc appender (haven't tried that one
though).

The performance appears to have gotten worse with WO5.4.  Is that
possible?

I have not noticed that, but is possible that you are doing something that is affected by changes in 5.4. I can't think of anything specific.

It might be, depending on the database plugin that is used and the database itself, that the SQL is different now and needs different indexes.

Good point - I will check what is being generated.



cug

_______________________________________________ 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
References: 
 >Slow SQL slowing application - how to speed things up? (From: Peter Newnam <email@hidden>)
 >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: Guido Neitzer <email@hidden>)

  • Prev by Date: Re: IERImageProcessor
  • Next by Date: Re: Slow SQL slowing application - how to speed things up?
  • Previous by thread: Re: Slow SQL slowing application - how to speed things up?
  • Next by thread: Re: Slow SQL slowing application - how to speed things up?
  • Index(es):
    • Date
    • Thread