CODEWITHSUNDEEP
solr
ilovetolearn
ilovetolearn

Reputation: 2060

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

Upvotes: 0

Views: 66

Answers (2)

Terry
Terry

Reputation: 452

You might use multiple cores to manage multiple entities that are different enough to justify having different indexes for each.

Upvotes: 0

Alexandre Rafalovitch
Alexandre Rafalovitch

Reputation: 9789

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.

Upvotes: 1

Related Questions