Reporting Optimizations now Available!
We hear regularly from our customers that having access to their business critical data is important to carry out their day to day business operations. We have made some important improvements to how quickly some of your most important reports are generated and delivered to you. These changes are so dramatic we will be rolling these improvements across all our supported production releases.
Lets take a look at how big of an improvement these reporting changes are. Below is a graph using some standard test data on how long it takes for a Customer CDR report to be generated. The X axis shows how many records are included in the report and the Y axis shows how long it takes to generate in seconds. The new reporting schema shows a nice flat linear line while the old times show a quadratic curve as you increased the number of CDRs included in the report.
|Customer CDR Reporting Improvements|
|Table 1: Graph shows the time to generate the report with the old scheme divided by the time to generate the report with the new scheme|
The second graph shows how big of an improvement shows how significant this change is to running your reports. We compared the runtime duration and divided by the new time for this value and the results will be quite dramatic. From The graphs you will see significant improvements to how long it takes to query the data for the Customer CDRs report. A 47x reduction on the amount of time to pull nearly a month of CDR data was made through this change. To put this in context a report with over 21.5 million CDR records can now be queried in under 15 minutes whereas before it would take almost 11 and a half hours.
|Customer CDRs Reporting time vs Number of Records|
|Table 2: Graph shows the time to generate the report in relation to how many CDRs are retrieved in the query.|
We have already tested out the changes for our Customer CDR reports and have already started working on implementing the changes for ASR/ACD reports and plan to address many other reports in the near future.