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

Improve performances of the tracker report renderer table when displaying artifact links

Download Browse

This contribution works on two fronts: * reducing the number of SQL queries * caching results that may be used multiple times to avoid recomputing it each time While it would be preferable to separate the part doing the caching and the part really dealing with data but the current architecture of the tracker form elements does not allow to do this kind of changes safely. Therefore while that is not ideal, this contribution uses local caches quite conservatively to help solving the performance issue. Only the list and text fields are using a local cache in this contribution: these fields are either intensive in terms of SQL queries or CPU. This is part of request #12245: Displaying an artifact with a lot of artifact links is slow Change-Id: I26b4d2f4ecadb55dfbee6b245cefe35a6beb6452

+44 −9
Thomas Gerbet (tgerbet) 2018-09-07 16:45
Thomas Gerbet (tgerbet) 2018-09-10 17:29
2a5b247f7645290c821ce52d99f1161a327a58cf
f21e534e8577a9e3140253120cfbb65df9dec191
git #tuleap/stable/2a5b247f7645290c821ce52d99f1161a327a58cf

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_List.class.php +10 −2 Go to diff View file
M plugins/tracker/include/Tracker/FormElement/Tracker_FormElement_Field_Text.class.php +20 −4 Go to diff View file
M plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php +14 −3 Go to diff View file