Hi Guys,

/I am upgrading from solr 4.2 to 6.0.//
//I successfully (after some time) migrated the config files and other parameters.../

Now I'm just wondering if my indexes are following the best practices...(and they are probably not :-) )

What would be the best if we have this kind of sql data to write in Solr:


I have several different services which need (more or less), different data based on these JOINs...

e.g.:
Service A needs lots of data (but bot all),
Service B needs a few data (some fields already included in A),
Service C needs a bit more data than B(some fields already included in A/B)...

*1. Would it be better to create one single index?**
**-> i.e.: this will duplicate journal info for every single article**
**
**2. Would it be better to create several specific indexes for each similar services?** **-> i.e.: this will use more space on the disks (and there are ~70millions of documents to join)

3. Would it be better to create an index per table and make a join?
-> if yes, how??

*

Kind regards,
Bastien

Reply via email to