Hello all, I'm new in Elasticsearch and trying to find out why my query performance is so slow. I have an index with 1M documents called "variantlist". I'm searching in "VariantIds" values with this query: {"from":0,"query":{"terms":{"VariantIds.8":["382"]}},"size":10000,"_source":{"includes":["V…

What struck me here is that in the mapping the variantIds are mapped to long. This datatype is optimise for range searches, but you are using a terms query. I think you should try to map those fields as keyword if you don't need range searches.

Improving Query Performance

Elastic Stack Elasticsearch

cthibodeau July 16, 2019, 4:14pm 14

I've found that the more documents you are asking for, the more ES memory you will need (we do query with size: 1.000.000)

Topic		Replies	Views
Is Elasticsearch suitable for efficient retrieval of large number of docs? Elasticsearch	15	1422	November 29, 2022
Term query is very slow if size != 0 Elasticsearch	9	1458	July 7, 2018
Elasticsearch 5 - Large (size) query performance with complex mapping Elasticsearch	2	1094	July 18, 2017
How can I tune for Elasticsearch performance? Elasticsearch	9	643	May 18, 2020
Slow query performance with a large size value Elasticsearch	6	1568	July 6, 2017

Improving Query Performance

Related topics