Filter By with 2 Combination Very Slow

Hi Master,

I’ve tried to filter my product (GridView) based on two combination (SKU and price), why it took a long time? almost 260.000 ms on symfony profiler. Generally without combination only take about 10.000 ms – 15.000 ms. Anyway, how to optimize it ? any suggestion sir :D

Thanks in advance

Topic

[Andrey YatsenkoModerator]

In the profiler, you can “explain” the query to see how it can be optimized, for example by adding indices and so on. But you should notice that this will optimize only some cases, as filtering has a lot of combinations it’s hard to optimize all of them without side effects.

At the Enterprise Edition, we have product grid rendered using ElasticSearch, and it works way faster than the search using DBAL driver.

Also if you are using some old version, consider to upgrade, we recently optimized the DBAL search performance. For community edition, they were applied in 1.6.11 version, 3.0 and master branches.

[Author]

Replies