Denormalize. Think about a view that shows your results page. Put that view in Solr. Query and get ready for speed.
wunder On Sep 28, 2012, at 5:34 PM, Biff Baxter wrote: > Hi Jack, > > The queries we need to do have a lot in common with SQL queries in that they > are field specific, but we need lots of fuzzy stuff so SQL won't do. Speed > is > also an issue. > > I will provide sample queries and data if needed. For now, I am waiting to > hear > back from jimtronic. > > Thanks for your reply. > > Biff > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/need-best-solution-for-indexing-and-searching-multiple-related-database-tables-tp4009857p4011007.html > Sent from the Solr - User mailing list archive at Nabble.com.
