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
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.
*