Hi there,
on sunday we are launching a prestashop with around 50.000 products. We will grade up to around 150.000 products within the next 12 weeks. All products have around 5-15 attributes. We have heaps of variants, but do not use the variant functionality of prestashop. It is disabled. We have them in a seperate system and only rendering a variant configurator via elasticsearch on the product page that then redirects to the proper product details page.
Everything works pretty fine, except the performance of the product category/ listing pages. Especially when the category has lots of products. Product detail page performance is awesome! One category has around 40.000 products, and the page loading time is around 3.5 s which is way too slow. I gave everything I found so far a try. It's not related to php (7.2), debug mode, profiler, caching or something else.
Also when I disable the category tree and the faceted search module I do not get much better performance. I see that even if I load 24 products per page, there is around 120 queries against product page. When I enable faceted search module, there is around 4000 queries per page load. probably related due to our amount of attributes.
Does someone have a idea what to do? The only chance I see so far is really overwriting the core code with my custom queries or use elasticsearch to render products on client side. Maybe someone of the presta core team if there is a chance to fix this in prestashop?
Would really appreciate your help!
Thanks a lot,
riu