The timings (per query) don't look significant at all - which tells me that indexing of your products table is fine - the load is a result of volume rather than slow queries however the query consuming the majority of time taken in the message from your host (a SELECT by product name ordered by price with LIMIT 1) would be coming from a modification so I'd like to double check that for you - if you could email me from this installation if standalone Price Tapestry;
...or if the site is using the PriceTapestry.org for WordPress plugin which I think you have been using;
pto.php pto_search.php pto_products.php
...and if you could also let me know in your email what level of configuration access you have to your hosting account e.g. if VPS and you have access to MySQL configuration (/etc/my.cnf) I'll check it out further with you...
Hello George,
The timings (per query) don't look significant at all - which tells me that indexing of your products table is fine - the load is a result of volume rather than slow queries however the query consuming the majority of time taken in the message from your host (a SELECT by product name ordered by price with LIMIT 1) would be coming from a modification so I'd like to double check that for you - if you could email me from this installation if standalone Price Tapestry;
search.php
products.php
html/searchresults.php
html/product.php
...or if the site is using the PriceTapestry.org for WordPress plugin which I think you have been using;
pto.php
pto_search.php
pto_products.php
...and if you could also let me know in your email what level of configuration access you have to your hosting account e.g. if VPS and you have access to MySQL configuration (/etc/my.cnf) I'll check it out further with you...
Cheers,
David.
--
PriceTapestry.com