Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Improve performance of Appropriation Resolution report

Description

User would like the Appropriation Resolution Report to generate in a reasonable amount of time.

Testing against

  • Gallia Co for 2019, report generation took between 15-19 minutes to complete.

  • Pickerington 2020 1 hour, option #3

To Do:

  • Update AppropriationResolutionDetail to not store the reference to the Appropritaion.

    • Change getters to properties and store the amount from the Appropriation.

    • Leave getFYTDAppropriation() as a getter that add the FYTDAppropriated and priorYearEncumbrance amounts.

  • Evaluate performance after making the above changes. Profile report creation if needed.

 

Jodi to Benchmark report runs and include information in comments below so we have metrics on the improvements made.

  • Done, see comments below.

 

 

Environment

None

Confluence content

mentioned on

Activity

Jason Klinger April 24, 2020 at 10:40 PM
Edited

Benchmarks for metrics using current QA1 data; time in minutes

Beginning Balance: Before 4:39 After 0:07 - 99.97% improvement
Next Year Proposed: Before 1:31 After 0:04 - 99.96% improvement
FTD Appropriated, Carryover and Totals: Before 17:03 After 0:09 - 99.99% improvement
FTD Appropriated, minus Carryover: Before 11:00 After 0:07 - 99.99% improvement

Jason Klinger April 14, 2020 at 12:41 PM

Testing:
Verify that all versions of the Appropriation Resolution report run correctly.

Jason Klinger April 14, 2020 at 12:40 PM
Edited

I reran the benchmarks on my local system as they were a bit longer than the docker server instances. Updated benchmarks after changes:

  • Beginning Balance: 5:56 -> 3:22 (43% improvement)

  • Next Year Proposed: 2:13 -> 2:23 (no improvement)

  • FTD Appropriated, Carryover and Totals: 15:03 -> 5:20 (65% improvement)

  • FTD Appropriated, minus Carryover: 11:17 -> 4:43 (58% improvement)

Jodi Becher March 31, 2020 at 7:01 PM
Edited

Benchmarks for metrics using current QA1 data; time in minutes

  • Beginning Balance  4:39

  • Next Year Proposed  1:31 (report was empty)

  • FTD Appropriated, Carryover and Totals  17:03

  • FTD Appropriated, minus Carryover  11:00 

Fixed

Details

Assignee

Reporter

Story Points

Fix versions

Times Requested

7

Source

Time tracking

3d 2h logged

Sprint

Priority

Parent

Better PDF Exporter

Created July 25, 2019 at 5:34 PM
Updated May 4, 2020 at 8:28 PM
Resolved May 4, 2020 at 8:28 PM

Flag notifications