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
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