[
https://issues.apache.org/jira/browse/SOLR-8037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14740029#comment-14740029
]
Yonik Seeley commented on SOLR-8037:
------------------------------------
Performance was tested on various fields in an index with 5M docs and some
deleted documents.
Timing measurements were done by the client and thus represent all phases of
the request (reading, query parsing, execution, response writing).
Rough performance results:
Filter production for range queries covering 1-10 terms:
||unique terms in field||speedup||
|100|161%|
|1000|77%|
|10000|76%|
|100000|79%|
|1000000|51%|
Filter production for range queries covering all terms in field:
||unique terms in field||speedup||
|100|133%|
|1000|116%|
|10000|55%|
|100000|18%|
|1000000|6%|
Query performance containing range queries with 100% cache hits on filter cache
- medium range queries (matching ~100 terms):
||unique terms in field||speedup||
|100|134%|
|1000|24%|
|10000|23%|
|100000|2%|
|1000000|4%|
Query performance containing range queries with 100% cache hits on filter cache
- range queries covering all terms:
||unique terms in field||speedup||
|100|118%|
|1000|90%|
|10000|170%|
|100000|438%|
|1000000|908%|
> speed up term range queries, use filter cache for embedded ranges
> -----------------------------------------------------------------
>
> Key: SOLR-8037
> URL: https://issues.apache.org/jira/browse/SOLR-8037
> Project: Solr
> Issue Type: Improvement
> Reporter: Yonik Seeley
> Attachments: SOLR-8037.patch
>
>
> Enhance term range queries (i.e. not numeric) by
> - Implement DocSetProducer to directly construct filters (fq, etc) for term
> range queries
> - Allow range queries that are part of other queries to automatically use the
> filter cache if the number of terms is large enough.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
