Hi Walter, I have bought into the denormalize approach. My remaining questions are around how to construct the denormlized view and any solr functions that would support issues related to a) minimizing the denormalization explosion for 3 or more tables and b) handling many to many relationships.
One issue I am concerned with is, if I search for IBM and Steve Jones in my example above, no records should be returned. How do I manage that with the equivalent of the one denormalized record approach? I appreciate your help. Biff -- View this message in context: http://lucene.472066.n3.nabble.com/need-best-solution-for-indexing-and-searching-multiple-related-database-tables-tp4009857p4011010.html Sent from the Solr - User mailing list archive at Nabble.com.
