Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

stable

Clone or download

Read-only

request #13408: Display of a tracker table report can be slow due to a confusion of the MySQL optimizer

Download Browse

The query built to retrieve information for the tracker table report now only pass the last changeset IDs to retrieve and let MySQL do the join by itself with the tracker_artifact table. In some cases giving both the artifact IDs and the changeset IDs seems to confuse MySQL. No functionnal change is expected. The display of the tracker table report should in the worst case takes as much time as of now or, in the best case, be massively improved. Change-Id: I85fa5fbbc4b29294ab5f2e6351ada375c38a7560

+2 −4
Thomas Gerbet (tgerbet) 2019-05-24 13:36
Thomas Gerbet (tgerbet) 2019-05-24 13:36
103d5a541fbf025d031a0f5ed05b3cdc6f489a98
f018e4bc959193974b9758e8c400f5536f97a85d
git #tuleap/stable/103d5a541fbf025d031a0f5ed05b3cdc6f489a98

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php +2 −4 Go to diff View file