linaslp Posted September 18, 2014 Share Posted September 18, 2014 Hello, I have 5000 products in one category "Padangos". The problem is layered navigation. If 15 people start to filter products. Server usage goes wild and reach 360 percent usage 4 cores were working with 15 people online. This makes page unusable. Or just try to click a lot of times in filter checkboxes and it will generate Hudge ammounts of mysql quaeries http://gyazo.com/08a...9a0aadbe87b5e57 I indexed all prices,URL and ect. The question would be: How to fix this problem. How to make layered navigation module not to use CPU so much. If it's imposible with layered navigation maybe another modules you using with a lot of products? Suggestions and any kind of help would be verry appreciated. Anyone maybe had the same problem and solved it somehow from another perspective? I am open to any king of suggestions Prestashop version 1.6.0.6 Layered nav version. v2.0.1 my project: pad ango splius.lt (remove spaces) Link to comment Share on other sites More sharing options...
El Patron Posted September 18, 2014 Share Posted September 18, 2014 can you provide a link to a product using layered navigation? Link to comment Share on other sites More sharing options...
linaslp Posted September 19, 2014 Author Share Posted September 19, 2014 Yes i can www.padangosplius.lt Link to comment Share on other sites More sharing options...
PrestaShark Posted September 19, 2014 Share Posted September 19, 2014 Hi. Your site works very well. Module work fast for me Link to comment Share on other sites More sharing options...
El Patron Posted September 19, 2014 Share Posted September 19, 2014 Like PrestaShark I had no issue, but if you provide link to exact product you are having issue it will be easier for review. Link to comment Share on other sites More sharing options...
mohitsareen Posted September 19, 2014 Share Posted September 19, 2014 HI I have a similar problem with layered navigation block. The speed is super slow my website is springwel.in We have only about 60 products but there are in all 17,000 combinations. When i click on the top level category i.e. mattress it takes more than 45 seconds for TTFB springwel.in/42-mattresses even subcategories take longer around 25 sec but i guess since lesser products are associated with them, they sort of crunch the data slightly faster. The million dollar question is what is the resolution for this... 45 sec is not acceptable (BTW, server is not a bottleneck, it's a dual 4 core server with 32GB RAM). Is the slowness directly proportional to the number of associations??? any way to get around this?? Any ideas will be appreciated... Thanks Link to comment Share on other sites More sharing options...
linaslp Posted September 22, 2014 Author Share Posted September 22, 2014 Answer for El patron and Prestashark. Yes when there are few people server works fine because as like mohitsareen server is dual 4 core. It can eat 15 people. Thats the point that you can't see the bug until "hudge" amount of people comes. I tested with my server statistics, i can see how much CPU working at the right moment when i'am clicking on layered navigation checkboxes. So if more people uses layered navigation it just uses FULL proccesor and presta stops loading pages. I understand that it's verry hard for you guys to see the exat problem, but the problem is there lying in silence I had suggestion to use memcache. Could this solve the issue? Can you suggest any other modules for similar layered navigation? Link to comment Share on other sites More sharing options...
mohitsareen Posted September 22, 2014 Share Posted September 22, 2014 (edited) Okay Guys.. Just for your information... My programmer resolved the issue by making a mod... We had approx. 8500 rows in each of the 2 tables i.e. Product_attribute and Product_attribute_shop table and when the layered navigation was getting executed it was mapping each attribute from each row to all the rows in the other table so resulting in 8500 X8500 reads. Resolution : Create a view using both the tables in the database and then let the layered navigation query execute TTFB reduced to 6 sec from 45 sec :-) Edited September 22, 2014 by mohitsareen (see edit history) Link to comment Share on other sites More sharing options...
fransjaeger Posted October 18, 2014 Share Posted October 18, 2014 Resolution : Create a view using both the tables in the database and then let the layered navigation query execute Hi Could you please explain a little more. Im new to Presta and curious if I should do something to my shop in this matter? Thank You Link to comment Share on other sites More sharing options...
El Patron Posted October 18, 2014 Share Posted October 18, 2014 Okay Guys.. Just for your information... My programmer resolved the issue by making a mod... We had approx. 8500 rows in each of the 2 tables i.e. Product_attribute and Product_attribute_shop table and when the layered navigation was getting executed it was mapping each attribute from each row to all the rows in the other table so resulting in 8500 X8500 reads. Resolution : Create a view using both the tables in the database and then let the layered navigation query execute TTFB reduced to 6 sec from 45 sec :-) thanks for sharing! this is an excellent point, one must add templates! Hi Could you please explain a little more. Im new to Presta and curious if I should do something to my shop in this matter? Thank You Having multiple templates configured rather than one large one would significantly reduce load time. Link to comment Share on other sites More sharing options...
fransjaeger Posted October 19, 2014 Share Posted October 19, 2014 I find the Layered Navigation Block has too many issues and even though i fix them, i wont be fully satisfied with it, so I deactivated it. Looking for a better filtering module. Considering the Advanced Search 4 module 1 Link to comment Share on other sites More sharing options...
elburgl69 Posted April 4, 2015 Share Posted April 4, 2015 I find the Layered Navigation Block has too many issues and even though i fix them, i wont be fully satisfied with it, so I deactivated it. Looking for a better filtering module. Considering the Advanced Search 4 module Is advanged search 4 an alterantive? Link to comment Share on other sites More sharing options...
Recommended Posts