MDR is essential when the data volumes are so large that the processing time to run your reports is unacceptable. If you are able to write a report that runs within acceptable time-constraints then the use of MDR may not be required. However, even if your report runs within 2 hours (and this is considered acceptable) you are still able to use MDR to bring this run-time down even further.
It is our consideration that almost any report that executes in the background can gain benefits by being implemented in MDR. This is because the MDR format not only promotes performance improvements, but also cost reductions in maintenance by having a generic format. It also provides the benefit of separating the processing and presentation logic. Separate presentation logic allows the data to be viewed interactively and in a user-friendly manner – far easier than lengthy static list output.
Post your comment on this topic.