BigW Consortium Gitlab

  1. 31 Aug, 2017 2 commits
  2. 30 Aug, 2017 1 commit
  3. 28 Aug, 2017 4 commits
  4. 25 Aug, 2017 1 commit
  5. 23 Aug, 2017 2 commits
    • Cache the number of open issues and merge requests · 6ec53f5d
      Yorick Peterse authored
      Every project page displays a navigation menu that in turn displays the
      number of open issues and merge requests. This means that for every
      project page we run two COUNT(*) queries, each taking up roughly 30
      milliseconds on GitLab.com. By caching these numbers and refreshing them
      whenever necessary we can reduce loading times of all these pages by up
      to roughly 60 milliseconds.
      
      The number of open issues does not include confidential issues. This is
      a trade-off to keep the code simple and to ensure refreshing the data
      only needs 2 COUNT(*) queries instead of 3. A downside is that if a
      project only has 5 confidential issues the counter will be set to 0.
      
      Because we now have 3 similar counting service classes the code
      previously used in Projects::ForksCountService has mostly been moved to
      Projects::CountService, which in turn is reused by the various service
      classes.
      
      Fixes https://gitlab.com/gitlab-org/gitlab-ce/issues/36622
  6. 18 Aug, 2017 1 commit
  7. 14 Aug, 2017 1 commit
  8. 13 Aug, 2017 1 commit
  9. 10 Aug, 2017 2 commits
  10. 08 Aug, 2017 1 commit
  11. 07 Aug, 2017 2 commits
  12. 01 Aug, 2017 1 commit
  13. 28 Jul, 2017 1 commit
    • Merge issuable "reopened" state into "opened" · 6ef87a20
      Yorick Peterse authored
      Having two states that essentially mean the same thing is very much like
      having a boolean "true" and boolean "mostly-true": it's rather silly.
      This commit merges the "reopened" state into the "opened" state while
      taking care of system notes still showing messages along the lines of
      "Alice reopened this issue".
      
      A big benefit from having only two states (opened and closed) is that
      indexing and querying becomes simpler and more performant. For example,
      to get all the opened queries we no longer have to query both states:
      
          SELECT *
          FROM issues
          WHERE project_id = 2
          AND state IN ('opened', 'reopened');
      
      Instead we can query a single state directly, which can be much faster:
      
          SELECT *
          FROM issues
          WHERE project_id = 2
          AND state = 'opened';
      
      Further, only having two states makes indexing easier as we will only
      ever filter (and thus scan an index) using a single value. Partial
      indexes could help but aren't supported on MySQL, complicating the
      development process and not being helpful for MySQL.
  14. 24 Jul, 2017 1 commit
  15. 14 Jul, 2017 1 commit
  16. 07 Jul, 2017 3 commits
    • Remove many N+1 queries with merge requests API · b963d45c
      Stan Hu authored
      Identified via `ENABLE_BULLET=1 bundle exec rspec spec/requests/api/merge_requests_spec.rb:34`
      
      Improves speed of #34159
    • fix spec · 6d28ad84
      James Lopez authored
    • Speed up `all_commit_shas` for new merge requests · 4c0864fd
      Sean McGivern authored
      For merge requests created after 9.4, we have a `merge_request_diff_commits`
      table we can get all the SHAs from very quickly. We just need to exclude these
      when we load from the legacy format, by ignoring diffs with no serialised
      commits.
      
      Once these have been migrated in the background, every MR will see this
      improvement.
  17. 06 Jul, 2017 4 commits
    • Add table for merge request commits · aff5c9f3
      Sean McGivern authored
      This is an ID-less table with just three columns: an association to the merge
      request diff the commit belongs to, the relative order of the commit within the
      merge request diff, and the commit SHA itself.
      
      Previously we stored much more information about the commits, so that we could
      display them even when they were deleted from the repo. Since 8.0, we ensure
      that those commits are kept around for as long as the target repo itself is, so
      we don't need to duplicate that data in the database.
    • Rename ActiverecordSerialize cop · e1a3bf30
      Yorick Peterse authored
      This cop has been renamed to ActiveRecordSerialize to match the way
      "ActiveRecord" is usually written.
    • Added Cop to blacklist the use of `dependent:` · 8fbbf41e
      Yorick Peterse authored
      This is allowed for existing instances so we don't end up 76 offenses
      right away, but for new code one should _only_ use this if they _have_
      to remove non database data. Even then it's usually better to do this in
      a service class as this gives you more control over how to remove the
      data (e.g. in bulk).
    • Add many foreign keys to the projects table · c63e3221
      Yorick Peterse authored
      This removes the need for relying on Rails' "dependent" option for data
      removal, which is _incredibly_ slow (even when using :delete_all) when
      deleting large amounts of data. This also ensures data consistency is
      enforced on DB level and not on application level (something Rails is
      really bad at).
      
      This commit also includes various migrations to add foreign keys to
      tables that eventually point to "projects" to ensure no rows get
      orphaned upon removing a project.
  18. 26 Jun, 2017 1 commit
  19. 21 Jun, 2017 1 commit
  20. 20 Jun, 2017 1 commit
  21. 16 Jun, 2017 1 commit
  22. 15 Jun, 2017 1 commit
  23. 31 May, 2017 2 commits
  24. 29 May, 2017 1 commit
  25. 23 May, 2017 2 commits
  26. 18 May, 2017 1 commit