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

Kira Traynor commented on SOLR-16758:
-------------------------------------

Thanks for the response! I've attached the patch to the ticket that I applied 
and did testing on to get the difference in query latencies. I wanted to get 
some concrete examples that I could actually share with a valid test and that 
you could reproduce. 
To test, I created local instances of solr (one with the current version of 
solr and the other with the patch) and indexed 2 million documents and was 
comparing the results with the following query: 
{code:java}
{!graph from=node_s to=edge_ss maxDepth=1 v='*:*'}{code}
In the patch I included a performance test within org.apache.solr.search.join 
called testGraphQueryPerformance(). The createGraphIndex() method generates a 
test index with an id, a node, and an edge value to be able to be queried with 
the graph query. To create the index on the local instances of solr, I 
generated documents using the same method. 
Running performance tests against the local instances of solr, I found that the 
changes to the graph query produced distinct differences (on average ~20% 
faster). 

> GraphQuery Performing Slower in Solr 9
> --------------------------------------
>
>                 Key: SOLR-16758
>                 URL: https://issues.apache.org/jira/browse/SOLR-16758
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>            Reporter: Kira Traynor
>            Priority: Major
>         Attachments: GraphQuery.patch
>
>
> We found that the changes made in SOLR-14185 with the GraphQuery slowed down 
> the performance of the graph join by around 50%. Reverting the changes made 
> in that pr to use a `Filter` object to get the `DocIdSet` rather than using a 
> `DocIdSetIterator`, sped the query times up in our tests to be more similar 
> to what we were seeing with the Solr 8 graph joins.
> The same change was made to the JoinQuery class so possibly slower 
> performance can be found there as well.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org

Reply via email to