Hi, I am just starting to learn about solr. I want to test it in my env working with ms sql server.
I have followed the tutorial and imported some rows to the Solr. Now I have a few noob question regarding the benefits of implementing Solr on a sql environment. 1. As I understand, When I send a query request over http, I receive a result with ID from the Solr system and than I query the full object row from the db. Is that right? Is there a comparison next to ms sql full text search which retrieves the full object in the same select? Is there a comparison that relates to db/server cluster and multiple machines? 2. Is there a technic that will assist me to estimate the volume size I will need for the indexed data (obviously, based on the indexed data properties) ?
