Re: Many to Many Mapping with Solr

2016-05-01 Thread Sandeep Mestry
Thanks Alexandre, even I am of the opinion not to use solr rdbms way but i am concerned about the updates to the indexes. We're expecting around 500 writes per second to the database which will generate in >500 updates to the index per second. If the entities are denormalised this will have an impa

Re: Many to Many Mapping with Solr

2016-04-29 Thread Joel Bernstein
We really still need to know more about your use case. In particular what types of questions will you be asking of the data? It's useful to do this in plain english without mapping to any specific implementation. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Apr 29, 2016 at 9:43 AM, Alexa

Re: Many to Many Mapping with Solr

2016-04-29 Thread Alexandre Rafalovitch
You do not structure Solr to represent your database. You structure it to represent what you will search. In your case, it sounds like you want to return 'user-records', in which case you will index the related information all together. Yes, you will possibly need to recreate the multiple document