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 #9981 Assigned/submitted Tracker widget is slow and unaccurate

Download Browse

Improve perf of with assigned_to query. On very big deployment 900k artifacts drops to 3.8 seconds (from more than 90s). Change-Id: I00a106d547e646e5c5db8a773dc7bedebc433a7f

+89 −18
Manuel Vacelet (vaceletm) 2017-03-06 14:55
Manuel Vacelet (vaceletm) 2017-04-06 15:11
c3400741f34b16597bb82f9f3836432e4769d0ed
6ceee9c6a637ec621b197823239d4c854af3e6c2
git #tuleap/stable/c3400741f34b16597bb82f9f3836432e4769d0ed

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/db/install.sql +2 −1 Go to diff View file
A plugins/tracker/db/mysql/updates/2017/201704051751_add_index_to_tracker_changeset_value_list.php +72 −0 Go to diff View file
M plugins/tracker/include/Tracker/Artifact/dao/Tracker_ArtifactDao.class.php +15 −17 Go to diff View file