[Xapian-discuss] Emulating SQL JOIN in xapian

[Olly Betts]

On Wed, Feb 25, 2009 at 09:26:49PM +0000, James Aylett wrote:
> On Wed, Feb 25, 2009 at 09:20:07PM +0000, Simon Roe wrote:
> 
> > 1) Simply duplicate the recipient information on every payment record.
> > This is possible as there aren't likely to be more than 20 payments
> > per recipient and I have the disk space.  I can see this speeding
> > everything up too.
> 
> This will work, and I believe is the most obvious way of attacking the
> problem in Xapian, if you must do so.

I wonder if there's a way to achieve this with PostingSource and
MatchSpy.

While I don't think Xapian should aspire to be an RDBMS, if we can
support this sort of thing mostly or entirely using existing features,
that would probably be worthwhile.

Cheers,
    Olly