You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Yonik Seeley (JIRA)" <ji...@apache.org> on 2016/10/05 01:01:20 UTC

[jira] [Comment Edited] (SOLR-9599) Facet performance regression using fieldcache and new DV iterator API

    [ https://issues.apache.org/jira/browse/SOLR-9599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15547253#comment-15547253 ] 

Yonik Seeley edited comment on SOLR-9599 at 10/5/16 1:01 AM:
-------------------------------------------------------------

A quick test of the same fields in the same index shows hits to sorting and function queries as well.

With a quick manual test, this was 51% slower:
{code}
http://localhost:8983/solr/collection1/query?q=*:*%20mydate_dt:NOW&fl=id&sort=s10_s%20desc,%20s100_s%20desc,%20s1000_s%20desc
{code}

And this was 78% slower:
{code}
http://localhost:8983/solr/collection1/query?q=*:*%20mydate_dt:NOW%20{!func%20v=$vv}&fl=id&vv=add(exists(s10_s),exists(s100_s),exists(s1000_s))
{code}


was (Author: yseeley@gmail.com):
A quick test of the same fields in the same index shows hits to sorting and function queries as well.

With a quick manual test, this was 51% slower:
http://localhost:8983/solr/collection1/query?q=*:*%20mydate_dt:NOW&fl=id&sort=s10_s%20desc,%20s100_s%20desc,%20s1000_s%20desc

And this was 78% slower:
http://localhost:8983/solr/collection1/query?q=*:*%20mydate_dt:NOW%20{!func%20v=$vv}&fl=id&vv=add(exists(s10_s),exists(s100_s),exists(s1000_s))


> Facet performance regression using fieldcache and new DV iterator API
> ---------------------------------------------------------------------
>
>                 Key: SOLR-9599
>                 URL: https://issues.apache.org/jira/browse/SOLR-9599
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>    Affects Versions: master (7.0)
>            Reporter: Yonik Seeley
>             Fix For: master (7.0)
>
>
> I did a quick performance comparison of faceting indexed fields (i.e. docvalues are not stored) using method=dv before and after the new docvalues iterator went in (LUCENE-7407).
> 5M document index, 21 segments, single valued string fields w/ no missing values.
> || field cardinality || new_time / old_time ||
> |10|2.01|
> |1000|2.02|
> |10000|1.85|
> |100000|1.56|
> |1000000|1.31|
> So unfortunately, often twice as slow.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org