Strange

[Daniel Kunkel]

Hi

I'm seeing some strange slowness in the ecommerce application (svn circa
Feb 2007) when viewing products or the catalog. Each catalog/product
page is taking around 10 seconds to create, even when the system is
fully unloaded. The other applications, and the checkout processes all
run normally.

Sun Solaris 10, Java 1.5..0_11

The log appears normal.

Truss is showing a repeated strange process locking error, Err#62:

4218/14:        29486.5501      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/14:        29486.6100      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/71:        29486.6701      lwp_cond_wait(0x09CA8270, 0x09CA8258,
0x7ADF37B0, 0) Err#62 ETIME
4218/67:        29486.6702      lwp_cond_wait(0x093114A0, 0x09311488,
0x7A62D9B0, 0) Err#62 ETIME
4218/14:        29486.6702      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/70:        29486.6701      lwp_cond_wait(0x0C1DD560, 0x0C1DD548,
0x7AEB9830, 0) Err#62 ETIME
4218/71:        29486.6705      lwp_mutex_timedlock(0x09311488,
0x00000000)     = 0
4218/68:        29486.6701      lwp_cond_wait(0x0B3C8BC0, 0x0B3C8BA8,
0x7AE77B30, 0) Err#62 ETIME
4218/69:        29486.6701      lwp_cond_wait(0x09E093D0, 0x09E093B8,
0x7AEFBAB0, 0) Err#62 ETIME
4218/67:        29486.6707      lwp_cond_wait(0x093114A0, 0x09311488,
0x00000000, 0) = 0
4218/71:        29486.6706      lwp_cond_signal(0x093114A0)
= 0
4218/14:        29486.7301      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/14:        29486.7901      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/14:        29486.8501      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0
4218/14:        29486.9101      pollsys(0x00000000, 0, 0x7E8F5BE0,
0x00000000)  = 0

I'm not sure what the problem is...  Does anyone have Any experience
with anything like this or ideas on what might be the next best step to
tracking it down?

Thanks

--
Daniel

*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!

Daniel Kunkel           [hidden email]
BioWaves, LLC           http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588    425-895-0050
http://www.Apartment-Pets.com  http://www.Illusion-Optical.com
http://www.Card-Offer.com      http://www.RackWine.com
http://www.JokesBlonde.com     http://www.Brain-Fun.com 
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

[Walter Vaughan]

Daniel Kunkel wrote:

> Hi
>
> I'm seeing some strange slowness in the ecommerce application (svn circa
> Feb 2007) when viewing products or the catalog. Each catalog/product
> page is taking around 10 seconds to create, even when the system is
> fully unloaded. The other applications, and the checkout processes all
> run normally.
>
> Sun Solaris 10, Java 1.5..0_11

<invoking Occam's Razor>

 From a client PD, use Firefox and use/install the Firebug add-in.
Then click on the green checkmark to expand Firebug.
Select the NET tab
It will then show you the load times for all the elements.

First you will be shocked at how long it takes to move all the CSS and JS files,
and then report back here how much the actual page (it should be the top
element) took to move back to your client.

If it is the page build time... what is the database you are using on the back
end. If you are using postgresql is autovacuum running, and if it is, when you
run it from a client like pgAdminIII does it complete in less than a minute or
does it crawl?

[Daniel Kunkel]

Hi

Great call Walter

In one case:

The page (top one) is done in 843 ms. Completely acceptable of course...

The contentForum css (as you predicted) was 19.35 seconds

Total 22.7 sec.

Other tests had the contentForum css coming up between 8 and 12 seconds.


Why would the css start loading so slowly after months of working fine?

Daniel



On Sun, 2007-06-03 at 21:13 -0400, Walter Vaughan wrote:

> Daniel Kunkel wrote:
>
> > Hi
> >
> > I'm seeing some strange slowness in the ecommerce application (svn circa
> > Feb 2007) when viewing products or the catalog. Each catalog/product
> > page is taking around 10 seconds to create, even when the system is
> > fully unloaded. The other applications, and the checkout processes all
> > run normally.
> >
> > Sun Solaris 10, Java 1.5..0_11
>
> <invoking Occam's Razor>
>
>  From a client PD, use Firefox and use/install the Firebug add-in.
> Then click on the green checkmark to expand Firebug.
> Select the NET tab
> It will then show you the load times for all the elements.
>
> First you will be shocked at how long it takes to move all the CSS and JS files,
> and then report back here how much the actual page (it should be the top
> element) took to move back to your client.
>
> If it is the page build time... what is the database you are using on the back
> end. If you are using postgresql is autovacuum running, and if it is, when you
> run it from a client like pgAdminIII does it complete in less than a minute or
> does it crawl?
>