usage of solr in ecommerce area what to index and what not to index

Question

I work in an e-commerce area dealing with a huge [300,000] no of products and related data like attributes, price, promotions, collections.

We are thinking to index all the information in solr and query from solr instead of any DB hits. We are thinking of going this way to provide good performance, easy sorting, and faceting features [some example]. We also have delta indexing for near real-time accuracy.

Is this a good decision or it should be a mix of solr and DB. Need some suggestions.

Answer 1

It all depends on your requirement. Solr is not a full replacement to your RDBMS.

You can migrate the relevant or important data to solr from RDBMS using the DIH feature of solr.

Whatever searching you want to execute you can perform on the solr server by HTTP requests.

You can also achieve sorting and faceting with solr.

And yes Delta indexing is also possible in solr.

Your decision of migrating the search relevant data is correct in order to improve the search performance of your application.

Yes it should be mix of RDBMS and solr for your application.