Performance Enhancements - Ledger04
Dateline: Roseville - June 30, 2008 - Stephanie Fury
I just had to follow up on my June 30th news post, because I have more exciting performance news about another report: the JE Fund/Object Summary (Ledger04).
This is used by many districts to balance to their county. It provides a summary of journal entries by type of transactions, time period,
department and other options.
Just like I described earlier, the stored procedures for the report were streamlined (this time by Chad) and I compared the "old" report to the "new" report. Here are the results:
| SQL Activity |
CPU Usage
(seconds) |
Read
Operations |
Write
Operations |
Elapsed Time
|
| Before |
69.23 |
66,538,350 |
1 |
73 minutes 54 seconds |
| After |
11.34 |
1,261,786 |
56 |
1 minute 8 seconds |
This is AMAZING! From over an hour to less than two minutes. As software and reports are developed and tested, I will continue to provide updates on our performance enhancements.
Comments? Send us an email and let us know what you think.
|
