Hello,
We have recently upgraded to elastic search 2.4.2 from 1.6.1. Our searches are taking double time then 1.6.1
One of query example here,
We have two types of documents.
- seller
- buyer.
Below is complex query we execute:
http://localhost:9200/{index_name}/buyer%2Cseller/_search?pretty -d '{"query":{"filtered":{"query":{"bool":{"should":[{"bool":{"must":[{"term":{"_type":"buyer"}},{"bool":{"should":[{"term":{"buyerName":"india darshan"}},{"match":{"buyerName":{"query":"india darshan","boost":6}}},{"match":{"buyerName.trigram":{"query":"india darshan","boost":4,"minimum_should_match":"50%"}}},{"simple_query_string":{"fields":["content^3.0","userName^2.0","userFullName^2.0","comments^1.0"],"query":"india darshan"}},{"simple_query_string":{"fields":["content^3.0","userName^2.0","userFullName^2.0","comments^1.0"],"query":"india* darshan*"}}]}}]}},{"bool":{"must":[{"term":{"_type":"seller"}},{"bool":{"should":[{"term":{"sellerName":"india darshan"}},{"match":{"sellerName":{"query":"india darshan","boost":8}}},{"match":{"sellerName.trigram":{"query":"india darshan","boost":4,"minimum_should_match":"50%"}}},{"simple_query_string":{"fields":["description^1.0"],"query":"india darshan"}},{"simple_query_string":{"fields":["description^1.0"],"query":"india* darshan*"}}]}}]}}]}},"filter":{"and":[{"term":{"orgId":196323}},{"term":{"deleted":0}}]}}},"_source":{"exclude":["content"]},"highlight":{"fields":{"content":{"fragment_size":150,"number_of_fragments":3,"no_match_size":150}}},"from":0,"size":40}'
Anything wrong in this in context to 2.4.2 upgrade?
These queries used to take around 3sec in 1.6 and now increased to 7 secs in 2.4.2