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

    Empty
    Dashboard & Widgets
    All
    Empty
    Empty
    Stage
    Marie Ange Garnier (marieange)
    Closed
    2018-11-12
    Attachments
    Empty
    References

    List of items referenced by or referencing this item.

    Artifact Tracker v5

    Follow-ups

    • User avatar
      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
      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
      • Original Submission