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 #12520 Missing index on svn_commit
    Actions
    Infos
    #12520
    Marie Ange Garnier (marieange)
    2018-11-12 13:26
    2018-11-09 18:27
    13228
    Details
    Missing index on svn_commit

    The following query (used in dashboard /svn widget) is slow

    SELECT svn_commits.revision as revision, svn_commits.id as commit_id, svn_commits.description as description, svn_commits.date as date, svn_commits.whoid FROM svn_commits WHERE svn_commits.group_id=XXX ORDER BY revision DESC  LIMIT 0,5;

     

    The index used for query is only the group_id one, so here if a project have many commit the request query all rows of project to only retrieve 5 rows.

    Dashboard & Widgets
    All
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2018-11-12
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #12269 Tuleap Releases 10.8 Delivered 2018-07-12 15:14 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #12520

    Git commit

    tuleap/tuleap/stable

    Merge 'gerrit #13094' into stable/master 7d37c52add
    User avatar Thomas Gerbet (tgerbet) , 2018-11-12 13:24
    request #12520 Missing index on svn_commit 0d08ecf71c
    User avatar Marie Ange Garnier (marieange) , 2018-11-12 12:25
    Referenced by request #12520

    Artifact Tracker v5

    rel #12269 10.8

    Other

    gerrit #13094
    Display settings

    Follow-ups

    User avatar
    Thomas Gerbet (tgerbet)2018-11-12 13:26
    Integrated in Tuleap 10.7.99.9.
    • Status changed from Under review to Closed
    • Connected artifacts
    • Close date set to 2018-11-12
    User avatar
    Thomas Gerbet (tgerbet)2018-11-12 11:36
    FYI, this query is typically executed when the list of commits of the SVN repo of a project is listed (from the widget or directly from the dedicated UI).

    A patch to add the index has been submitted to review by @marieange, see gerrit #13094.
    • Status changed from Under implementation to Under review
    User avatar
    Marie Ange Garnier (marieange)2018-11-09 18:31
    • 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