MantisBT: master f109d15d

Diff Back to Repository
Author Committer Branch Timestamp Parent
dregad dregad master 2024-03-13 14:13 master a6c90df1
Affected Issues  0034041: MantisGraph: last resolved issue not computed in Issue Trends graph
 0034042: MantisGraph: inefficient calculation of data sets for Issue Trends graph
Changeset

Optimize create_cumulative_bydate() function

Until today, the function was executing simple SQL queries returning
atomic data, and PHP code had to loop over each row to compute the total
number of reported and resolved Issues.

This reports the effort to aggregate the data on the database server,
greatly simplifying the PHP code

It also fixes a bug where the last resolved issue was sometimes not
computed, resulting in an incorrect result set.

Fixes 0034041,0034042
mod - plugins/MantisGraph/core/graph_api.php Diff File