MantisBT: master 64ee6226

Author Committer Branch Timestamp Parent
cproensa dregad master 2019-01-08 12:02 master 4b481cd3
Changeset

Redefine summary open, resolved, by dates

Previuos summary section "by dates" has to problems:

  1. 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.

  2. 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.

mod - core/summary_api.php Diff File