Re: Inserting data from multiple databases in same index

2010-07-22 Thread Chris Lu
You can either 1) create one index for each database, and merge the results during search. 2) create the 2 indexes individually and merge them 3) merge records during SQL select. The 1) approach should be easy to scale linearly as your database grows. You can even distribute the indexes onto seve

Inserting data from multiple databases in same index

2010-07-22 Thread L Duperval
Hi, We are creating an index containing data from two databases. What we are trying to achieve is to make our search locate and return information no matter where the data came from. (BTW, we are using Compass, if it matters any) My problem is that I am not sure how to create such an index. Do I