[
https://issues.apache.org/jira/browse/LUCENE-10562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17533751#comment-17533751
]
Tomoko Uchida edited comment on LUCENE-10562 at 5/9/22 10:57 AM:
-----------------------------------------------------------------
One thing I could recommend is, that instead of using wildcard queries for
suffix match, you could "reverse" each term and convert suffix match into
prefix match. ReverseStringFilter does the trick.
https://lucene.apache.org/core/7_4_0/analyzers-common/org/apache/lucene/analysis/reverse/ReverseStringFilter.html
was (Author: tomoko uchida):
One thing I could recommend is, that instead of using regex queries for suffix
match, you could "reverse" each term and convert suffix match into prefix
match. ReverseStringFilter does the trick.
https://lucene.apache.org/core/7_4_0/analyzers-common/org/apache/lucene/analysis/reverse/ReverseStringFilter.html
> Large system: Wildcard search leads to full index scan despite filter query
> ---------------------------------------------------------------------------
>
> Key: LUCENE-10562
> URL: https://issues.apache.org/jira/browse/LUCENE-10562
> Project: Lucene - Core
> Issue Type: Bug
> Components: core/search
> Affects Versions: 8.11.1
> Reporter: Henrik Hertel
> Priority: Major
> Labels: performance
>
> I use Solr and have a large system with 1TB in one core and about 5 million
> documents. The textual content of large PDF files is indexed there. My query
> is extremely slow (more than 30 seconds) as soon as I use wildcards e.g.
> {code:java}
> *searchvalue*
> {code}
> , even though I put a filter query in front of it that reduces to less than
> 20 documents.
> searchvalue -> less than 1 second
> searchvalue* -> less than 1 second
> My query:
> {code:java}
> select?defType=lucene&q=content_t:*searchvalue*&fq=metadataitemids_is:20950&fl=id&rows=50&start=0
> {code}
> I've tried everything imaginable. It doesn't make sense to me why a search
> over a small subset should take so long. If I omit the filter query
> metadataitemids_is:20950, so search the entire inventory, then it also takes
> the same amount of time. Therefore, I suspect that despite the filter query,
> the main query runs over the entire index.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
