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 #12471 Add missing index on ugroup_user

Download Browse

How to test: Table ugroup_user should have the missing index On request: SELECT ug.* FROM ugroup_user AS ug_u INNER JOIN user USING (user_id) INNER JOIN ugroup AS ug USING (ugroup_id) INNER JOIN groups AS g USING (group_id) LEFT JOIN user_group USING (group_id, user_id) INNER JOIN forgeconfig ON (forgeconfig.name = 'access_mode') WHERE ug_u.user_id = '10430' AND ( ( forgeconfig.value = 'restricted' AND ( user_group.group_id IS NOT NULL OR user.status = 'A' AND g.access IN ('public', 'unrestricted') OR user.status = 'R' AND g.access = 'unrestricted' ) ) OR ( forgeconfig.value <> 'restricted'AND ( user_group.group_id IS NOT NULL OR g.access <> ('private') ) ) ); With this index we improve search from: | Handler_read_key | 20145 | | Handler_read_next | 20142 | to: | Handler_read_key | 6 | | Handler_read_next | 2 | Change-Id: If6e5c538b713f33bf0fa8a8dbae3ce4aec36822a

+39 −1
Marie Ange Garnier (marieange) 2018-10-30 13:45
Marie Ange Garnier (marieange) 2018-10-31 10:21
f914af4434f387dfef99f79225b2b2496812a6ec
cfaf0f50677947564c91d3e9a020612dd017421d
git #tuleap/stable/f914af4434f387dfef99f79225b2b2496812a6ec

Modified Files

Side by side diff
Inline diff
Name
M src/db/mysql/database_structure.sql +2 −1 Go to diff View file
A src/db/mysql/updates/2018/201810301339_add_ugroup_user_index.php +37 −0 Go to diff View file