Skip to main content

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.

    •  
      request #12440 add missing index on user.ldap_id
    Actions
    Infos
    #12440
    Marie Ange Garnier (marieange)
    2018-10-26 11:37
    2018-10-25 14:51
    13112
    Details
    add missing index on user.ldap_id
    The following query (triggered by user autocompleter, user search, members ldap sync, …) is performing a full table scan because there is no index on user.ldap_id

    SELECT * FROM user WHERE ldap_id = 'abc'

    On a platform with lot of users it can take too much time to perform.
    Other
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2018-10-26
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #12268 Tuleap Releases 10.7 Delivered 2018-08-11 13:12 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #12440

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/70/12970/2' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD 2a5a0eb35d
    User avatar Nicolas Terray (nterray) , 2018-10-26 11:29
    part of request #12440 add missing indexes 7f514deb92
    User avatar Marie Ange Garnier (marieange) , 2018-10-25 15:45
    Referenced by request #12440

    Artifact Tracker v5

    rel #12268 10.7

    Other

    gerrit #12970
    Display settings

    Follow-ups

    User avatar
    Nicolas Terray (nterray)2018-10-26 11:37
    gerrit #12970 integrated into Tuleap 10.6.99.73
    • Summary
      -add missing indexes 
      +add missing index on user.ldap_id 
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    • Status changed from Under implementation to Closed
    • Connected artifacts
    • Close date set to 2018-10-26