RE: Help with a Join Query

2014-12-11 Thread EXTERNAL Taminidi Ravi (ETI, Automotive-Service-Solutions)
Sent: Thursday, December 11, 2014 1:23 PM To: solr-user@lucene.apache.org Subject: Re: Help with a Join Query Thanks, That looks like a viable option, I could do something like the following: q={!join from=parent to=id} &fq={!join from=parent to=id}color:red &fq={!join from=parent to=id}color:b

Re: Help with a Join Query

2014-12-11 Thread Kydryavtsev Andrey
According to may experience, "query time join" has relatively poor performance. If you can cache this joins effectively (not so many unique color values in requests, cache doesn't invalidate) - it's ok. If not, it may be interesting to try "block join" instead - http://blog.griddynamics.com/201

Re: Help with a Join Query

2014-12-11 Thread Kydryavtsev Andrey
11.12.2014, 21:24, "Darin Amos" : > Thanks, > > That looks like a viable option, I could do something like the following: > > q={!join from=parent to=id} > &fq={!join from=parent to=id}color:red > &fq={!join from=parent to=id}color:blue > > With all these joins happening like this, what kind of p

Re: Help with a Join Query

2014-12-11 Thread Darin Amos
Thanks, That looks like a viable option, I could do something like the following: q={!join from=parent to=id} &fq={!join from=parent to=id}color:red &fq={!join from=parent to=id}color:blue With all these joins happening like this, what kind of performance concern is this? I would guess this wou

Re: Help with a Join Query

2014-12-11 Thread Kydryavtsev Andrey
How about something like ({!join from=parent to=id}color:red) AND ({!join from=parent to=id}color:blue) ? 11.12.2014, 19:48, "Darin Amos" : > Hello, > > I am trying to execute a join query that I am not 100% sure how to execute. > Lets say I have a bunch of parent and child documents and every