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

chore: Filter trackers before query

Download Browse

Part of story #36833 search on semantics and always there fields even if not defined The query join on tables `groups` and `tracker` only in order to filter on which trackers we search. These 2 joins degrade query performance when we search on many trackers. This filter can be applied before directly on the list of tracker we use *No functional changes expected* Change-Id: Ic28c3ec30fc42797e1991ac31b0c34e3903ba305

+70 −93
Kevin Traini (ktraini) 2024-03-26 15:36
Kevin Traini (ktraini) 2024-04-03 14:42
c7be012a5129630fdb01b9693dd30958eacbe5d4
bf57749b249a350ff5148ab2a6bdb49a3b001448
git #tuleap/stable/c7be012a5129630fdb01b9693dd30958eacbe5d4

Modified Files

Side by side diff
Inline diff
Name
M plugins/crosstracker/include/CrossTracker/Report/CrossTrackerArtifactReportFactory.php +35 −60 Go to diff View file
M plugins/crosstracker/include/CrossTracker/Report/Query/Advanced/QueryBuilder/CrossTrackerExpertQueryReportDao.php +35 −33 Go to diff View file