Report performance tuning

By | 19th October 2016

Customer: Aviation Software House

Our customer had an important report that was taking over 10 minutes to run for just a month’s worth of data. New requirements mean that the report needed to be run for a year’s worth of data. Obviously a problem!

As is so often the case, the main performance problem was due to subreports. By removing one subreport and modifying the main report to use SQL Expressions in its place, we were able to reduce processing time to less than a minute.
That’s OK, but we can do better!
A few tweaks in the SQL of both the main report and the remaining subreport and processing time is down to about 20 seconds.
That’s a performance improvement from 10 minutes to 20 seconds.
Technologies:

  • Oracle Database
  • Crystal Reports

Leave a Reply

Your email address will not be published. Required fields are marked *