Re: performance bottleneck
Re: performance bottleneck
- Subject: Re: performance bottleneck
- From: Mike Schrag <email@hidden>
- Date: Thu, 4 Sep 2008 07:39:08 -0400
You can also turn on the thing in Wonder that logs out timing of
queries. Is the database in production running on the same machine as
the web app? Are you connecting to that database as localhost/
127.0.0.1 or the hostname? If hostname, check DNS -- this can kill
you DNS is setup wrong (you get huge DNS lags) ... So check that
locally you can resolve the hostname that appears in the URL, and
check that your DNS servers on that machine are correct. Drivers,
obviously. If you connect to the machine using a native db client on
the production box (with the same hostnames etc), is it still slow?
ms
On Sep 4, 2008, at 3:27 AM, Q wrote:
On 04/09/2008, at 3:35 PM, Lachlan Deck wrote:
Hi there,
I've been doing quite a bit of profiling on my app over the last
few days ... and well on my dev machine it's working a treat.
(However I do notice that using the displayGroup - even with using
ERXBatchingDisplayGroup + ERXDatabaseDataSource that there's a few
extra round-trips to the db that needn't be... but that's another
optimisation to come).
However, when I deploy my app to our intranet, the list pages are
seriously slow (even moving between batches). I'm connecting the
same database on both machines (mine connects remotely obviously)
but there's some serious bottleneck somewhere that I can't figure
out. Locally it's great, deployed is sluggish as anything.
Unfortunately I can't find a profiler for FreeBSD (the platform of
our deployment servers) ... so I'm wondering if anyone has any
other ideas?
Are you using the same version of the JDBC drivers?
Is it also slow if you use direct connect?
Have you checked Safari's "Inspect Element -> Network" to see where
the browser's time is being spent?
Is the JVM being allocated sufficient memory?
You may want to try narrowing down with some debug timing output if
it is slow to fetch the data, slow to render the components, or just
slow to send the data to the browser.
--
Seeya...Q
Quinton Dolan - email@hidden
Gold Coast, QLD, Australia (GMT+10)
Ph: +61 419 729 806
_______________________________________________
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
_______________________________________________
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