Amit, I'd say it depends on the types of queries you need to run. Maybe you mentioned that already, but your reply cut it off (Nabble....). I can say this with certainty: 1M is a small number and 30 fields is not a big deal. Otis ---- Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch Lucene ecosystem search :: http://search-lucene.com/
----- Original Message ---- > From: amit_ak <amit...@mindtree.com> > To: solr-user@lucene.apache.org > Sent: Wed, June 23, 2010 2:00:50 AM > Subject: Re: Nested table support ability > > Hi Otis, Thanks for the update. My paramteric search has to span > across customer table and 30 child tables. We have close to 1 million > customers. Do you think Lucene/Solr is the right fsolution for such > requirements? or database search would be more > optimal. Regards, Amit -- View this message in context: > href="http://lucene.472066.n3.nabble.com/Nested-table-support-ability-tp905253p916087.html" > > target=_blank > >http://lucene.472066.n3.nabble.com/Nested-table-support-ability-tp905253p916087.html Sent > from the Solr - User mailing list archive at Nabble.com.