• 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: Mon, 27 Apr 2009 10:09:46 +1000

On 10/04/2009, at 1:48 AM, Guido Neitzer wrote:

On 8. Apr. 2009, at 22:16 , Peter Newnam wrote:

Choke!   2 - 5 seconds on average?!!?  That is orders of magnitude
too
slow!  The bad news is that something is seriously wrong there (or
you
are deployed on an iPhone ;-).  The good news is that something is
seriously wrong so you should be able to find it quickly.

There are some serious issues with HUGE amounts of data being retrieved and turned into objects. Some serious refactoring is required.....

If that's an user centric app and you don't need the data, don't load it as one big chunk. Load then data, when you need it. Look at pre- fetching relationships.

The most important part:

Get SQL logging going and check where:

- SQL commands are slow that should be fast
- you retrieve large amounts of rows that aren't used / displayed
right away

Start from there before you do any refactoring. If you use
displayGroups and ProjectWonder, look into ERXBatchingDisplayGroup. If
you don't use Wonder, start using it.

cug

Thanks. ERXBatchingDisplayGroup looks interesting. I will check it out. We are using ProjectWonder but have only just converted the project to start using it so still getting to grips with it.


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

  • Prev by Date: Re: D2W
  • Next by Date: Variable method name signature
  • 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