spec/finders · 25b9d8e550ed97fd492b549c1a6e544e2445c77a · Forest Godfrey / gitlab-ce

Optimize query for User#groups_through_project_authorizations · a52b54f3

authored May 30, 2017

Instead of plucking paths, and doing LIKE/OR on each of them, use a subquery to
find groups that are the ancestor of the projects the user is member of.

a52b54f3

Name	Last commit	Last update
..
access_requests_finder_spec.rb		Loading commit data...
branches_finder_spec.rb		Loading commit data...
contributed_projects_finder_spec.rb		Loading commit data...
environments_finder_spec.rb		Loading commit data...
group_members_finder_spec.rb		Loading commit data...
group_projects_finder_spec.rb		Loading commit data...
groups_finder_spec.rb		Loading commit data...
issues_finder_spec.rb		Loading commit data...
joined_groups_finder_spec.rb		Loading commit data...
labels_finder_spec.rb		Loading commit data...
members_finder_spec.rb		Loading commit data...
merge_requests_finder_spec.rb		Loading commit data...
move_to_project_finder_spec.rb		Loading commit data...
notes_finder_spec.rb		Loading commit data...
personal_access_tokens_finder_spec.rb		Loading commit data...
personal_projects_finder_spec.rb		Loading commit data...
pipeline_schedules_finder_spec.rb		Loading commit data...
pipelines_finder_spec.rb		Loading commit data...
projects_finder_spec.rb		Loading commit data...
snippets_finder_spec.rb		Loading commit data...
tags_finder_spec.rb		Loading commit data...
todos_finder_spec.rb		Loading commit data...