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 #10689: Missing indexes on cross_references table

Download Browse

If you add the cross_references field as a column in a report, on some setup with some cross references, you should not have slow query. Time: -33 s (-97%) 34.3 s → 941 ms Change-Id: I560ce178eea91f4b2496229df0365e50daea5974

+69 −2
Nicolas Terray (nterray) 2017-09-26 14:54
Nicolas Terray (nterray) 2017-09-26 14:56
4087b9b854d8906cfb82bc5b08e80d08b72616e3
8b8fc2a57fcde4aa467f8da6a3d0074b042547e1
git #tuleap/stable/4087b9b854d8906cfb82bc5b08e80d08b72616e3

Modified Files

Side by side diff
Inline diff
Name
M src/db/mysql/database_structure.sql +3 −2 Go to diff View file
A src/db/mysql/updates/2017/201709261432_add_index_for_cross_references.php +66 −0 Go to diff View file