Re: Slow SQL slowing application - how to speed things up?
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