# TermsLookupQueryBuilder slower in Elasticsearch 2.x than 1.x

**URL:** <https://discuss.elastic.co/t/termslookupquerybuilder-slower-in-elasticsearch-2-x-than-1-x/82111>\
**Category:** Elasticsearch\
**Created:** [April 12, 2017, 8:02am UTC](https://discuss.elastic.co/t/termslookupquerybuilder-slower-in-elasticsearch-2-x-than-1-x/82111 "2017-04-12T08:02:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ultimate.duwal](https://avatars.discourse-cdn.com/v4/letter/u/2acd7d/32.png) [@ultimate.duwal](https://discuss.elastic.co/u/ultimate.duwal)\
**Post date:** [April 12, 2017, 8:02am UTC](https://discuss.elastic.co/t/termslookupquerybuilder-slower-in-elasticsearch-2-x-than-1-x/82111/1 "2017-04-12T08:02:40Z")

</div>

Hello,

I have been using **TermsLookupFilterBuilder** _([https://www.elastic.co/guide/en/elasticsearch/reference/1.4/query-dsl-terms-filter.html](https://www.elastic.co/guide/en/elasticsearch/reference/1.4/query-dsl-terms-filter.html))_ without caching in ES 1.4 which seems be be faster than **TermsLookupQueryBuilder** _([https://www.elastic.co/guide/en/elasticsearch/reference/2.4/query-dsl-terms-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/2.4/query-dsl-terms-query.html))_ in ES 2.4, which is slower than 10 times for my sample query, which aggregates to few minutes for my original query. The query were tested for both Java API and also normal ES query.

**Is this expected ? Is there any other way for optimization?**

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 10, 2017, 8:04am UTC](https://discuss.elastic.co/t/termslookupquerybuilder-slower-in-elasticsearch-2-x-than-1-x/82111/2 "2017-05-10T08:04:26Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.