Thanks Jan, I found out late last night that my assumption of the virtuemart multi-level slowdown was the problem. It wasn't. We moved the virtuemart category to a 2nd level and it's still SUPER slow.

What would cause some virtuemart categories to be slow and others not?? If I disable Artio Joomsef, it flies.

Thanks

OK, ran some more tests and we have confirmed that the deeper the category level in Virtuemart, the slower JoomSef MySQL queries get. When you get 4 levels deep, pages are taking 30-60 seconds to load vs instant for products 2 categories deep.

If you disable JoomSEF, everything loads instantly.

Any thoughts? This is killing our performance right now.

Just upgraded our client boothmed.com to the latest JoomSef plus Virtuemart extension and when you get 3-4 levels deep in the categories, MySQL takes a huge hit.

If I disable JoomSef, they are almost instant but, when enabled, CPU goes back up.

Thoughts?

www.boothmed.com/tuttnauer-autoclave-parts.html

Click on any one of the top links to see what I'm talking about.