SyliusElasticsearchPlugin icon indicating copy to clipboard operation
SyliusElasticsearchPlugin copied to clipboard

Optimize shop products query builder by making enabled column to be q…

Open panakour opened this issue 1 year ago • 0 comments

The must option in elastic should be using in queries where we care about the score. If you want to query columns like published/unpublished or something similar the score is redundant and you can use the filter instead.

The filter clause is often more performant because Elasticsearch can cache the results and optimize the execution.

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html

panakour avatar Dec 12 '23 10:12 panakour