# Elasticsearch + Java - Can you further optimize this query?

**URL:** https://discuss.elastic.co/t/elasticsearch-java-can-you-further-optimize-this-query/325357
**Category:** Elasticsearch
**Created:** [February 13, 2023, 6:36am UTC](https://discuss.elastic.co/t/elasticsearch-java-can-you-further-optimize-this-query/325357 "2023-02-13T06:36:21Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Java2avaj](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/java2avaj/32/99497_2.png) [@Java2avaj](https://discuss.elastic.co/u/Java2avaj)
#### Post date: [February 13, 2023, 6:36am UTC](https://discuss.elastic.co/t/elasticsearch-java-can-you-further-optimize-this-query/325357/1 "2023-02-13T06:36:21Z")

</div>

We have an elasticsearch that contains millions of records and we are using it for a global searching. However, our query takes 2-4 seconds to return result. Can somebody help or advice how to further optimize the following query:

```auto
    NativeSearchQueryBuilder query = new NativeSearchQueryBuilder()
    .withQuery(QueryBuilders.boolQuery()
        .should(QueryBuilders.termQuery("name", searchText))
        .should(QueryBuilders.termQuery("key", searchText))
        .should(QueryBuilders.termQuery("sort_alpha", searchText))
        .should(QueryBuilders.termQuery("sort_number", searchText))
    ).withPageable(PageRequest.of(0, 100))
    .withHighlightFields(new HighlightBuilder.Field("name"),
        new HighlightBuilder.Field("key"),
        new HighlightBuilder.Field("sort_alpha"),
        new HighlightBuilder.Field("sort_number")
    .build();

```

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [February 13, 2023, 7:15am UTC](https://discuss.elastic.co/t/elasticsearch-java-can-you-further-optimize-this-query/325357/2 "2023-02-13T07:15:28Z")

</div>

What is the value of the took field in the response object?

---

<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: [March 13, 2023, 7:16am UTC](https://discuss.elastic.co/t/elasticsearch-java-can-you-further-optimize-this-query/325357/3 "2023-03-13T07:16:21Z")

</div>

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