Categorized in:
m-Fin REVENUE AND EXPENDITURE TOTAL Tuning
January 4, 2013 by Carl Sorenson
We are improving the performance of m-Fin REVENUE AND EXPENDITURE TOTAL on project id’s and on large orgnodes (i.e. orgnodes having 100+ orgs). I invite you to test in Cognos QA. If you have windows open to Cognos production you may need to close them.
Let us know your test results by leaving a reply on this blog post.
- If the production version of the report has been running well for you, confirm that the QA version of the report also runs well.
- If the production version of the report has been running poorly for you (sometimes taking minutes to do what it did in seconds just moments before, or simply not running certain parameters well), confirm that performance is improved in the QA version of the report.
Example run-times
Here highlighted in green are examples of improved run-times we’ve experienced this week with the QA version of the report:
| QA | Production | |
|---|---|---|
| Large orgnode S0007 | 15 seconds | Inconsistent, occasionally taking minutes |
| Large orgnode C0001 but just fund 80 | 08 seconds | Same |
| Small orgnode D0017 | 12 seconds | Same |
| Large project 1543911 | 10 seconds | 1 minute |
| Normal sized project 1546517 | 05 seconds | Same |
| Two normal sized speedtypes 11020234 13000099 | 05 seconds | Same |
| Large award NNG07HW00C | 12 seconds | Same |
Add new comment