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

SQL query to retrieve assigned or created artifacts by a user is slow and inaccurate

Download Browse

This contribution reuses a similar optimization than the one introduced by commit c3400741f34 but for the "assigned or created" query. It also fixes the overfiltering of the query, artifacts created by the user but where the contributor/assignee field is missing/incomplete were not returned. This is a part of request #9981: Assigned/submitted Tracker widget is slow and unaccurate Change-Id: I353e240c2a6e54101be8ee379286499f8efbb631

+22 −22
Thomas Gerbet (tgerbet) 2017-08-10 14:07
Thomas Gerbet (tgerbet) 2017-08-10 14:47
d720f748599611ab781ad1bd8eeb8f8df84e91a4
06215028113dbed181877ee5248e6fd3bf13e44d
git #tuleap/stable/d720f748599611ab781ad1bd8eeb8f8df84e91a4

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/include/Tracker/Artifact/dao/Tracker_ArtifactDao.class.php +22 −22 Go to diff View file