fireblade669 wrote:Hi there,
Just wondered if anyone has found a way to improve speed (perhaps indexes) when using Ajax Filters with a large(ish) number of products and filters. I have 700 products with 4600 Specification Attribute mappings, 500 Variant Attribute mappings and then I'm also using the price range filter. Can be seen in action here: http://www.mypad.je/sofa .
We're seeing time to first byte of about 1.7 seconds on the above page. If I remove the filter control, it decreases to about 0.7 seconds.
Any ideas much appreciated.
Hi fireblade669,
The strange thing is that the Ajax Filters does cache the model after the first request and it should be really fast when you open the same category for a second time as no requests to the database are made afterwards.
You can try to Clear the Cache from the administration and measure it, although nopCommerce also caches the Category navigation on the left and it should be much slower.
We will test locally why even though there is caching in the Filters it takes one more second as you describe.
Thanks