Re: Nested table support ability

2010-06-23 Thread Otis Gospodnetic
Nutch Lucene ecosystem search :: http://search-lucene.com/ - Original Message > From: amit_ak > 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 searc

Re: Nested table support ability

2010-06-23 Thread Govind Kanshi
Amit - unless you test it would not be apparent. Key piece is as Otis mentioned "flatten everything". This requires effort from your side to actually create documents in manner suitable for your searches. The relationship needs to be "merged" into the document. To avoid storing text representations

Re: Nested table support ability

2010-06-22 Thread amit_ak
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

Re: Nested table support ability

2010-06-18 Thread Otis Gospodnetic
Hello, The short answer is that you need to flatten everything. Your index then has some column-db-like redundancy, but queries become simple and flat. But: See http://blog.sematext.com/2010/06/02/lucene-digest-may-2010-3/ and https://issues.apache.org/jira/browse/LUCENE-2454 in particular