yasin939

I think when doing product filtering it performs queries with JOINs and to speed up those queries we also need to index all relevant tables (As raised in this thread).

pa_{attribute} – Product Attributes for filtering.

Ran mysqltuner.pl and get the following:
Joins performed without indexes: 271
join_buffer_size (> 256.0K, or always use indexes with JOINs)

As you can see it’s asking to use indexes for all JOINs.

Hope this helps to add keys to Tables where Product Attributes are stored.

The previous upload was with the following hardware config:
4GB RAM
2 CPU Core

I did run monitor again after bumping up a server to the following:
8GB RAM
4 CPU Core

Upload ID is still the same DTpgsCCU

I hope it has captured what is required in the same ID.

After upgrading the server, query speed has increased but feel it can still be optimized by correct indexing.

Looking forward to an update on your findings.

Just to make you aware page caching is disabled on all category pages and a link to one of the category page is given in the previous message.

If need any more info please do reach out to me and will be more than happy to provide required details.

The monitor is uploaded with ID DTpgsCCU

Looking forward to getting the extremely slow product filtering issue resolved. As more and more filters are added it slows down to up to 20-25 seconds.

Website Link Tested on : https://yasam.co.uk/product-category/bedroom-furniture/wardrobe/