|
Changeset |
Redefine summary open, resolved, by dates
Previuos summary section "by dates" has to problems:
-
The criteria for "opened" issues, is by submit date. But the criteria
for "resolved" is based on history log for transition, from unresolved,
into resolved status. The main reason is that we don't have a specific
resolution date.
If having issues with succesive resolve and reopen transitions, and
those history records fall between different day ranges, the balance
result can be incorrect.
-
The queries for history table are considerably slow, and there is a
query for each day range. It all adds to the summary page response time.
The change here consist of:
- Using the same criteria for opened issues, where every new issue, or
reopen, history log counts for the total.
- Every open or resolve transition, for a given issue, is counted
separately.
This way we get a more accurate balance indicator, and ideally, for
every new/reopen action, we should have a resolution action.
Additionally, after this change in criteria, the history data can be
aggregated and extracted with one query for all date ranges, thus
greatly improving the performance issues. |