Re: Join support across multiple document types in Lucene

2012-06-29 Thread Erick Erickson
Performance here is an issue. The performance of Solr/Lucene's query joins is a function of the number of _unique_ values in the fields being joined, and can be unacceptably slow in the wild, it depends on your use-case. denormalization is the usual approach, but that gives DB folks the hives. Bu

Join support across multiple document types in Lucene

2012-06-29 Thread Frank DeRose
All, I have a question about join support across multiple document types in Solr/Lucene. Let me lay out the use case. Suppose I have 3 tables: * Table A has 3 columns, id, a1, a2. * Table B has 4 columns, id, b1, b2, and aid, which is a foreign key referencing A.id. *