Performance Enhancements - Ledger04

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.