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>
