# Lucene Wildcard Search taking too much time

**URL:** https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721
**Category:** Elasticsearch
**Created:** [March 23, 2017, 9:55am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721 "2017-03-23T09:55:00Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![sampathkore4444](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sampathkore4444](https://discuss.elastic.co/u/sampathkore4444)
#### Post date: [March 23, 2017, 9:55am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/1 "2017-03-23T09:55:00Z")

</div>

Hi Team,

Lucene Wildcard Search is taking around 1 minute to give the results.

Number of hits : 13000  
Lucene Version : 5.5.2

Kindly let me know the problem or at least few suggestions.

Please find the attached log

at com.apache.lucene.store.DataInput.readVInt(DataInput.java:109)  
at com.apache.lucene.index.TermBuffer.read(TermBuffer.java:87)  
at com.apache.lucene.index.SegmentTermEnum.next(SegmentTermEnum.java:134)  
at com.apache.lucene.search.FilteredTermEnum.next(FilteredTermEnum.java:78)  
at com.apache.lucene.search.FilteredTermEnum.setEnum(FilteredTermEnum.java:57)  
at com.apache.lucene.search.WildcardTermEnum.(WildcardTermEnum.java:65)  
at com.apache.lucene.search.WildcardQuery.getEnum(WildcardQuery.java:59)  
at com.apache.lucene.search.MultiTermQueryWrapperFilter.getDocIdSet(MultiTermQueryWrapperFilter.java:107)  
at com.apache.lucene.search.ConstantScoreQuery$ConstantWeight.scorer(ConstantScoreQuery.java:139)  
at com.apache.lucene.search.BooleanQuery$BooleanWeight.scorer(BooleanQuery.java:298)  
at com.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:578)  
at com.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:383)

Thanks in advance.

Regards,  
Sampath.

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [March 23, 2017, 10:05am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/2 "2017-03-23T10:05:08Z")

</div>

I think you will need to provide some additional information in order for anyone to be able to answer.

- What version of Elasticsearch are you on?
- What is the specification of the cluster in terms of node count, CPUs, RAM and storage?
- How much data are you querying? How many shards do you have?
- What does the query you are running look like?

---

<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: [March 23, 2017, 10:07am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/3 "2017-03-23T10:07:31Z")

</div>

And also: don't use wildcards as written here: [Wildcard Query | Elasticsearch Guide [5.2] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/5.2/query-dsl-wildcard-query.html)

> Note that this query can be slow, as it needs to iterate over many terms.

---

<div class="post-metadata">

### Author: ![sampathkore4444](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sampathkore4444](https://discuss.elastic.co/u/sampathkore4444)
#### Post date: [March 23, 2017, 11:01am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/4 "2017-03-23T11:01:17Z")

</div>

Hi Christian,

please find the below information,

Lucene Version: 5.5.2 (Not an Elastic Search)  
No of nodes: 4 (Clustered Environment)  
Search String : Comcast\* AND insattach:false AND pyClassGroup:WB-TO-TOPSRF-Work\* AND NOT insexternal:true

Regards,  
Sampath.

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [March 23, 2017, 11:04am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/5 "2017-03-23T11:04:53Z")

</div>

As David pointed out, wildcard queries can be slow. See if you can index and query your data in a way that avoids wildcard queries.

---

<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: [April 20, 2017, 11:05am UTC](https://discuss.elastic.co/t/lucene-wildcard-search-taking-too-much-time/79721/6 "2017-04-20T11:05:06Z")

</div>

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