[ https://issues.apache.org/jira/browse/LUCENE-9002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949103#comment-16949103 ]
Guoqiang Jiang edited comment on LUCENE-9002 at 10/11/19 3:34 AM: ------------------------------------------------------------------ Hi, [~jpountz], I provide a Patch [PR-940|https://github.com/apache/lucene-solr/pull/940] which refer to [LUCENE-8027|https://issues.apache.org/jira/browse/LUCENE-8027]. I would add our considerations and test results, please help me to review.:) was (Author: jgq2008303393): Hi, [~jpountz], I provide a Patch [PR-940|https://github.com/apache/lucene-solr/pull/940] which refer to [LUCENE-8027|https://issues.apache.org/jira/browse/LUCENE-8027]. I would add our considerations and test results, please help me to review. > query caching leads to absurdly slow queries > -------------------------------------------- > > Key: LUCENE-9002 > URL: https://issues.apache.org/jira/browse/LUCENE-9002 > Project: Lucene - Core > Issue Type: Improvement > Components: core/search > Affects Versions: 7.7.2, 8.2 > Reporter: Guoqiang Jiang > Priority: Major > Labels: cache, performance > Time Spent: 10m > Remaining Estimate: 0h > > *Description* > We have dozens of ES clusters(based on Lucene) for metric scenarios. Most of > the queries are like this: _host_ip:10.10.10.10 AND timestamp:[2019-10-01 > 00:00:00 TO 2019-10-05 23:59:59]_. And we frequently encounter some absurdly > slow queries. > *Solution* > For a long time range query(e.g. 5 days), each range query will consume tens > of megabytes of memory and spend hundreds of milliseconds to cache, but the > benefits are not obvious. And those large cache entries will cause frequent > cache eviction. So it's better to skip the caching action directly when > large range query appears with a selective lead iterator. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@lucene.apache.org For additional commands, e-mail: issues-h...@lucene.apache.org