Joomla Virtuemart too many SQL queries fix improvement

my site has been suspended by my host (shared hosting via siteground) due to the following:

"...the problem was exactly due to very slow SQL queries which are in turn slowing down the whole service"

My site info:

PHP Built on: Linux [url removed, login to view] #6 SMP Fri Feb 20 02:45:11 CST 2009 i686

Database Version: 5.0.91mm-log

Database Collation: utf8_general_ci

PHP Version: 5.2.9

Web Server: Apache/[url removed, login to view] (Unix) mod_gzip/[url removed, login to view] mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/ mod_ssl/[url removed, login to view] OpenSSL/0.9.8e-fips-rhel5 PHP-CGI/0.5

Web Server to PHP interface: cgi

Joomla! Version: Joomla! [url removed, login to view] Stable [ Wojmamni Ama Mamni ] 05-November-2009 04:00 GMT

User Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; en-US) AppleWebKit/534.13 (KHTML, like Gecko) Chrome/[url removed, login to view] Safari/534.13

with debug turned on the following is typical of a page load:

Profile Information

Application afterLoad: 0.000 seconds, 0.24 MB

Application afterInitialise: 0.044 seconds, 2.50 MB

Application afterRoute: 0.086 seconds, 4.23 MB

Application afterDispatch: 0.579 seconds, 11.20 MB

Application afterRender: 0.749 seconds, 14.32 MB

Memory Usage


1207 queries logged

I also noticed 989 legacy queries logged

I have upgraded to Virtuemart 1.7, used phpMyadmin to optimise tables and tried turning off SEF to help the problem, but whilst it has improved the queries is still too high.

Once this is resolved I will also be looking to move hosting to a cloud provider (not SITEGROUND!) and also have 6 other sites. Therefore potential for additional work, but for now need this fixing ASAP.

Evner: Joomla, MySQL, PHP, Virtuemart

Se mere: virtuemart sql queries, virtuemart queries, queries virtuemart, joomla database queries, joomla legacy queries logged, virtuemart sql, virtuemart sql legacy queries, virtuemart slow application afterrender, virtuemart queries sql, legacy queries logged joomla, virtuemart slow sql, queries logged virtuemart, joomla sql queries, joomla queries, virtuemart web service, unix service, sg2, need sql help, need a cloud for web service,, legacy com, intel com, legacy queries logged, joomla virtuemart sql queries, sql queries page php

Om arbejdsgiveren:
( 0 bedømmelser ) plymouth, United Kingdom

Projekt ID: #947207

4 freelancere byder i gennemsnit $148 på dette job


Please check PMB

$200 USD på 1 dag
(345 bedømmelser)

Please see my PM for details.

$150 USD på 1 dag
(2 bedømmelser)

Hi, We are professional Web Designer and Developers... Please Check our PM

$120 USD på 1 dag
(3 bedømmelser)

Expert in Joomla and Virtuemart. 1 Day - and you have fast site without slowly mysql queries.

$120 USD på 1 dag
(1 bedømmelse)