Re: Configure my Database in Solr

2011-09-28 Thread Lance Norskog
How large are your individual tables, and how many possible joins are there? The general advice for schemas (Solr and Lucene) is to use one per database and denormalize denormalize denormalize. Solr&Lucene are very fast even with hundreds of millions of (small) documents. The new Group Collapsing

Configure my Database in Solr

2011-09-28 Thread Cynthia Dematteis-Krug - Xsite GmbH
Good morning, I am new in Solr and i do not find any technical support to ask, only this address. I hope i am ok here. I used to work in Lucene and we created there one index per table. This way, if we wanted to search products, we use the "Products" index, if we wanted to search in customers, w