Category section load slow after moving from shared to VPS?

[kobra]

on his new VPS and whenever we load the admin>>catalog>>categories section it loads in like 30 seconds.

On the shared server it loaded almost instantly

This all boils down to server configuration of the LAMP stack

There are forums dedicated to that subject
Only one might be
webhostingtalk.com

[tripflex]

This all boils down to server configuration of the LAMP stack

There are forums dedicated to that subject
Only one might be
webhostingtalk.com

Yeah i searched on there and couldn't find that much, i found a thread on here too about "optimizing" the page, but that didn't help much either.

Can you be anymore specific by what you mean when you say LAMP stack?

[kobra]

Can you be anymore specific by what you mean when you say LAMP stack?

Optimizing the elements
Linux
Apache
Mysql
Php

[tripflex]

Ok i had my data center level 3 techs look into it and they said they tweaked a couple things but it's still taking about the same time.

Maybe so i can help them out a little bit, does the categories just load from a mysql database? Does zencart cache the category listings or does it load them each time?

Just trying to figure out a little bit more behind the category listing so hopefully we can try and figure out the problem

[DrByte]

There is limited internal caching.

Instead, tweak your mysql (my.cnf) to maximize memory use to improve performance. Perhaps consider looking at your better-performing server's config and comparing that with your poorly-performing server's config.

[tripflex]

Thanks for the reply, i already tweaked the my.cnf to higher settings than we have on the shared server...

The only solution i have found thus far is to disable the category counting and the page loads fine. But this is something that the client wants to have and says "well it worked fine on the shared server so i want it on my vps as well"

This just has us stumped, i've even had some of our best level 3 linux techs look at it and they don't know what could cause it.

That's why im just trying to get more information about how categories are loaded, where, when, how they are cached, and so forth so i can pass it along to them.

Thanks for everyone's help so far, still haven't figured out a solution yet though.

[kobra]

What are the page parse times?