Re: Graph query extremely slow

2019-06-01 Thread Rahul Goswami
Hi Toke, Thanks for the sharing the sanity check results. I am setting rows=100. The graph fq in my case gives a numFound of a little over 1 million. The total number of docs is ~4 million. I am using the graph query in an fq. Could the performance differ between having it in an fq vs q ? Also, si

Re: Graph query extremely slow

2019-05-22 Thread Toke Eskildsen
On Wed, 2019-05-15 at 21:37 -0400, Rahul Goswami wrote: > fq={!graph from=from_field to=to_field returnRoot=false} > > Executing _only_ the graph filter query takes about 64.5 seconds. The > total number of documents from this filter query is a little over 1 > million. I tried building an index i

Re: Graph query extremely slow

2019-05-20 Thread Toke Eskildsen
On Sun, 2019-05-19 at 14:34 -0400, Rahul Goswami wrote: > Just following up in case my previous email got lost in the big stack > of queries. Would appreciate any help on optimizing a graph query. Or > any pointers on the direction to investigate. This seems related to https://issues.apache.org/j

Re: Graph query extremely slow

2019-05-19 Thread Rahul Goswami
Hello experts, Just following up in case my previous email got lost in the big stack of queries. Would appreciate any help on optimizing a graph query. Or any pointers on the direction to investigate. Thanks, Rahul On Wed, May 15, 2019 at 9:37 PM Rahul Goswami wrote: > Hello, > > I am running

Graph query extremely slow

2019-05-15 Thread Rahul Goswami
Hello, I am running Solr 7.2.1 in standalone mode with 8GB heap. I have an index with ~4 million documents. Not too big. I am using a graph query parser to filter out some documents as below: fq={!graph from=from_field to=to_field returnRoot=false} Both from_field and to_field are indexed and of