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

emrealtan (Emre Altan) July 22, 2019, 11:53am 21

Yes, I saw that just after I replied your comment. Now it's more faster because of the smaller response data size. There's one last thing to do: convert this query to NEST, but this is subject of another topic

Anyways, thank you all!

Topic		Replies	Views
Is Elasticsearch suitable for efficient retrieval of large number of docs? Elasticsearch	14	1454	November 1, 2022
Term query is very slow if size != 0 Elasticsearch	8	1478	June 9, 2018
Elasticsearch 5 - Large (size) query performance with complex mapping Elasticsearch	1	1105	June 20, 2017
How can I tune for Elasticsearch performance? Elasticsearch	8	664	April 20, 2020
Slow query performance with a large size value Elasticsearch	5	1590	July 16, 2015

Improving Query Performance

Related topics