Hi David,
I have 5 large price tapestry sites on one server that have between 500k and 800k products on each.
I'm receiving a reasonable amount of traffic to them but unfortunately I'm also using a large amount of CPU.
I've been informed by my host that examples of processes taking a large amount of time are:
| 27344 | username_blah | localhost | username_database | Query | 0 | Copying to tmp table | SELECT id,name,normalised_name,image_url,description,price,rating,MIN(price) AS minPrice, COUNT(id) | 0.000 |
With most of them being this query. Is there any way to optimise this or are the sites simply too big?
Thanks,
- Quentin
Hi David,
Sorry for the late reply. Thanks for pointing the thread out, it helped a lot as always!
Thanks,
- Quentin
Hi Quentin,
If you haven't come across it already check out this thread regarding MySQL configuration for large sites - in particular increasing sort_buffer_size and key_buffer_size significantly since the MySQL defaults are very small and this normally makes a big difference. If that's already in place or you have been able to make the changes but not noticing any significant change let me know and I'll check it out further with you...
Cheers,
David.
--
PriceTapestry.com