Question

What might be the explanation for the following scenario? A user reports that it took a longer than usual amount of time to access a document. Upon further investigation, the user tells you that the document he or she was attempting to access is from a budget report written two years ago.

Answer 1

Usually a report is fetched from the database where data from all previous years is available. Once data is fetched, the raw data is compiled and formulated into appropriate report. The reason that report took longer is that user might have selected a date range from last two years until now which means that entire two years data was fetched from the database, operations were performed onto the raw data and the compiled data was then adjusted as per the report output.