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>