| Issue Number | 769 |
|---|---|
| Summary | [Board Member Login Report] Explore ways to speed up report |
| Created | 2023-04-24 16:13:07 |
| Issue Type | Improvement |
| Submitted By | Shields, Victoria (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2023-05-09 07:05:30 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/oceebms/issue.344262 |
This report takes a very long time to run.
Consider the following changes:
1. Filtering the report by Board.
2. Checking to see if using raw SQL speeds things up so much that no further optimization is needed.
~vshields While investigating this, I noticed that the column for outstanding reviews show the same count for a member of multiple boards, regardless of which board sheet is being populated. Do you want this column to reflect the outstanding reviews each the board member has for the current sheet's board instead?
The report, which used to take several minutes, now finishes in a few seconds.
replaced the entity query API with the database API
added a custom "EBMS Server" property to workbook (so you can tell the report's tier)
separated out the per-board unreviewed article counts
added real authname values
made the authname column conditional (only where SSO
login is supported)
Enhancements installed on DEV.
Verified on QA.
Verified on PROD.
Elapsed: 0:00:00.000602