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

wei shen commented on SOLR-8251:
--------------------------------

I installed 5.5. I found that pure blank query it is much faster, however 
combined with filter query it is slower. It might be a different issue.

for query: q={!cache=false}*:*&fl=id&start=0&rows=2
solr 5.5(50ms) is much faster than solr4.7(400ms)

however, after add a fq clause
q={!cache=false}*:*&fq=+categoryIdsPath:1001&fl=id&start=0&rows=2
solr5.5 (130ms) is still slower than solr4.7 (70ms)

what's more, with the query with filter is slower compare to query without 
filter in 5.5.

one more experiment is that i disable the filtercache by adding 
"{!cache=false}" 
rows=2&fl=id&q={!cache=false}*:*&fq={!cache=false}categoryIdsPath:1001
solr5.5 (20-25ms) slightly faster than solr4.7(around 25-30ms), both are much 
faster comparing to using filter cache.

Any reason about that?
Shall I open a separate ticket on it?

> MatchAllDocsQuery is much slower in solr5.3.1 compare to solr4.7
> ----------------------------------------------------------------
>
>                 Key: SOLR-8251
>                 URL: https://issues.apache.org/jira/browse/SOLR-8251
>             Project: Solr
>          Issue Type: Bug
>          Components: search
>    Affects Versions: 5.3, 5.3.1
>            Reporter: wei shen
>            Assignee: Yonik Seeley
>             Fix For: 5.5, master
>
>         Attachments: Solr 4 vs Solr 5.png
>
>
> I am trying to upgrade our production solr instance from 4.7 to 5.3.1. 
> Unfortunately when I do load testing I find the MatchAllDocsQuery is much 
> slower in solr 5.3.1 compare to 4.7. (solr 5.3.1 is faster in load test with 
> queries other than MatchAllDocsQuery). I asked solr-user and discussed with 
> Yonik Seeley. He confirmed that he can see the problem too comparing solr 
> 5.3.1 and 4.10.
> here is the query I use:
> {code}
> q={!cache=false}*:*&fq=+categoryIdsPath:1001&fl=id&start=0&rows=2&debug=true
> {code}
> for me the query is consistently about 60-70% slower on solr5 than solr4.
> Yonik mentioned in his email "For me, 5.3.1
> is about 5x slower than 4.10 for this particular query."



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to