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

fix: add index on tracker_field(original_field_id)

Download Browse

This query is executed when a tracker admin edits a tracker field in form element administration. Without this index on platforms with 1M+ form elements, it can take up to 6s. With the index it's down to 15ms and the page is no longer slow to render. Closes request #24165 Modification of a tracker field is slow Change-Id: I11d19e1d26e265e319d1f2c06edda9046554bf26

+40 −1
Manuel Vacelet (vaceletm) 2021-11-23 10:11
Manuel Vacelet (vaceletm) 2021-11-23 10:11
099dcebf7d4cd0cb51e71a50f413ea99b3f6c563
4e1a823718701e519c4710282ab3a9b0da176cb4
git #tuleap/stable/099dcebf7d4cd0cb51e71a50f413ea99b3f6c563

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/2021/202111231007_add_index_tracker_field.php +38 −0 Go to diff View file