I'm facing the fact that 2 of my websites are limited by the hostingprovider. Both websites are on a shared server, use Virtuemart and the DarkMart template.
Website A is only used as a catalogue, has about 800 visitors a month and about 130 Virtuemart products. So not a heavy duty site to my opinion but is dealing with a Virtual Memory Usage problem, see attachment
Attachment cpu-websiteA.jpg not found
and is limited for that reason.
Website B has about 3000 visitors a month and contains about 1000 Virtuemart articles with subarticles, custom fields, stockinventory and cartfunctionality. The attachement
Attachment cpu-websiteB.jpg not found
shows the server behaviour of this website during the last 7 days. Yesterday I've moved this website to another shared server to see how it goes there.
Anyway, doing some other investigations about the problems with both websites I Activited the debugging option in Joomla in website B and noticed the enormous amount of database queries: about 1300 for the Virtuemart homepage and over 2000 for a category page! Too many db queries slows down the website.
I think this overkill of db queries has been frustrating the CPU's server a lot and that's why the site has been limited by the hostingprovider and has become more slow.
Selecting another template reduces the amount of database queries dramatically and I have other Virtuemart websites on this same shared server without any CPU problems, so after eliminating a few things I think maybe the template is causing the problems I'm facing at the moment.
Why is the template generating so many database queries?