Question
Tata Consultancy Services Ltd
US
Last activity: 27 Apr 2020 11:53 EDT
Performance comparison of reporting over RDBMS vs Elastic Search
Is there any reference where I can compare the performanance of reporting over RDBMS vs Elastic Search? From one of videos from library I found that we have the information in the below Mesh link but I don't have access to the content. Could some one from Pega access the link and publish the statistics?
https://mesh.pega.com/docs/DOC-132112
Thanks,
Suman
Accepted Solution
Updated: 27 Apr 2020 11:53 EDT
Pegasystems Inc.
PL
This document does not specify exact numbers, nor different type of reporting. It's only about aggregations.
The conclusion is definetly worth spreading:
"Most important conclusion in this test is that response time in ElasticSearch with aggregations is proportional to the size of the output returned, not to the number of input rows needed to be processed like in regular database. This is not just a few times faster database in all cases, but it uses different approach to data gathering, which turned out could be especially beneficial for data aggregations on big data sets."
Radek.