Eric, Unfortunately Solr guys ignores it.
On Tue, Aug 14, 2012 at 7:48 PM, Eric Khoury <ekhour...@hotmail.com> wrote: > > Hi Mikhail, was trying to figure out if solr-3076 made it into the beta, > but since the issue is still marked as opened, I take it it didn't > yet?Thanks,Eric. > > From: mkhlud...@griddynamics.com > > Date: Fri, 3 Aug 2012 00:06:36 +0400 > > Subject: Re: Solr 4.0 - Join performance > > To: ekhour...@hotmail.com; solr-user@lucene.apache.org > > > > Eric, > > > > you can take last patch from SOLR-3076 > > [image: Text File] > > < > https://issues.apache.org/jira/secure/attachment/12536717/SOLR-3076.patch> > > SOLR-3076.patch > > < > https://issues.apache.org/jira/secure/attachment/12536717/SOLR-3076.patch> > > 16/Jul/12 21:16 > > > > also can take it applied from > > https://github.com/m-khl/solr-patches/tree/6611 . But the origin source > > code might be a little bit old. > > Regaining a nightly build, it's not so optimistic - I can't attract > > committer for reviewing it. > > > > On Thu, Aug 2, 2012 at 11:51 PM, Eric Khoury <ekhour...@hotmail.com> > wrote: > > > > > Wow, great work Mikhail, that's impressive. > > > I don't currently have build the dev tree, you wouldn't have a patch > for > > > the alpha build handy? > > > If not, when do you think this'll be available in a nightly build? > > > Thanks again, > > > Eric. > > > > From: mkhlud...@griddynamics.com > > > > Date: Thu, 2 Aug 2012 22:38:13 +0400 > > > > Subject: Re: Solr 4.0 - Join performance > > > > To: solr-user@lucene.apache.org > > > > > > > > > > > Hello, > > > > > > > > You can check my record. > > > > > > > > https://issues.apache.org/jira/browse/SOLR-3076?focusedCommentId=13415644&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13415644 > > > > > > > > I'm still working on precise performance measurement. > > > > > > > > On Thu, Aug 2, 2012 at 6:45 PM, Eric Khoury <ekhour...@hotmail.com> > > > wrote: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Hello all, > > > > > > > > > > > > > > > > > > > > I’m testing out the new join feature, hitting some perf > > > > > issues, as described in Erick’s article ( > > > > > http://architects.dzone.com/articles/solr-experimenting-join). > > > > > > > > > > Basically, I’m using 2 objects in solr (this is a simplified > > > > > view): > > > > > > > > > > > > > > > > > > > > Item > > > > > > > > > > - Id > > > > > > > > > > - Name > > > > > > > > > > > > > > > > > > > > Grant > > > > > > > > > > - ItemId > > > > > > > > > > - AvailabilityStartTime > > > > > > > > > > - AvailabilityEndTime > > > > > > > > > > > > > > > > > > > > Each item can have multiple grants attached to it. > > > > > > > > > > > > > > > > > > > > The query I'm using is the following, to find items by > > > > > name, filtered by grants availability window: > > > > > > > > > > > > > > > > > > > > solr/select?fq=Name:XXX&q={!join > > > > > from=ItemId to=Id} AvailabilityStartTime:[* TO NOW] AND > > > > > -AvailabilityEndTime:[* > > > > > TO NOW] > > > > > > > > > > > > > > > > > > > > With a hundred thousand items, this query can take multiple seconds > > > > > to perform, due to the large number or ItemIds returned from the > join > > > > > query. > > > > > > > > > > Has anyone come up with a better way to use joins for these types > of > > > > > queries? Are there improvements planned in 4.0 rtm in this area? > > > > > > > > > > > > > > > > > > > > Btw, I’ve explored simply adding Start-End times to items, but > > > > > the flat data model makes it hard to maintain start-end pairs. > > > > > > > > > > > > > > > > > > > > Thanks for the help! > > > > > > > > > > Eric. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Sincerely yours > > > > Mikhail Khludnev > > > > Tech Lead > > > > Grid Dynamics > > > > > > > > <http://www.griddynamics.com> > > > > <mkhlud...@griddynamics.com> > > > > > > > > > > > -- > > Sincerely yours > > Mikhail Khludnev > > Tech Lead > > Grid Dynamics > > > > <http://www.griddynamics.com> > > <mkhlud...@griddynamics.com> > -- Sincerely yours Mikhail Khludnev Tech Lead Grid Dynamics <http://www.griddynamics.com> <mkhlud...@griddynamics.com>
