hi, I have no experience in this area, but I have a classic requirement to synchronize a sql server with elastic search databases to speed up searches. I should evaluate two strategies: the first to keep the data updated in real time to contemplate the other one scheduled update per day. schematically you might mention some of the components that come into play for the two scenarios? And in the second case what is the processing load for the db we are talking about a hundred million occurrences? thanks to the availability that you can pay to my request for information. regards
You can read that: http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/
It represents my opinion on this.