Search code examples
solr

solr schema design for 100 over tables

I am designing the schema for my solr server. I have 2 oracle databases and 100 over tables to index for these two tables.

How should I go about indexing these tables:

  1. 1 schema with multiple entity - each entity maps to 1 table
  2. 1 solr core for each database/table
Solution

  • You should not be thinking about this that way at all.

    Instead, you should think about what you will want to find, prototype that with a small data set and then figure out how to map your database to the search index.

    You may end up indexing a very small part of the database and getting back from Solr only relevant IDs which you then use to lookup your complex structures for the actual content.