Jocelyn Fournier

@Hlavtox That's my point, your second query without the limit clause doesn't return a lot of rows (only 361 lines). That means your facetedsearch applies a quite restrictive filter. I...

> I was skeptical, but considering the array consists only of product IDs, it seems that PHP shouldn't have to struggle too much to work on it and perform array_slice....

@matthieu-rolland price & bandwidth usages mostly, although there could be a small impact on performances depending of the speed of the connection between front servers and db servers.

@Hlavtox Yes it's possible, I'm running big customers on AWS or GCP. Decathlon for example is using Prestashop 8 with this kind of setup, so we want to avoid degrading...

> @jocel1 Hmmm hm hmmm. > > And are these kinds of big shops even using faceted search anymore? We have about 15k products on the biggest store and I...

@kpodemski yes there were some other optimisations in the module removed by the module upgrade, so I put back the original optimized module and I'm planning to patch it with...

> @jocel1 It would be great if you could share some perf mods in other places, if they are not client specific. 😜 one easy optimisation, but only useful with...

The impact on the DB load is visible (after May 17th here): No significant changes on the DB global bandwidth. Benchmark from an AWS Aurora 3.06.0 DB instance based on...

Hi @Dridi! For the first one : `(?i)(ads|google|bing|msn|yandex|baidu|ro|career|seznam|)bot` is stricly equivalent to `(?i)bot` since we have at the end and empty "|" condition The main reason to add "google" is...

up @florine2623 @kpodemski