delta/gitlab/gitlab-ce.git/app/controllers/dashboard/projects_controller.rb, branch git-user-encoding

Resolve "DashboardController#activity.json is slow due to SQL"

2017-11-06T16:52:56+00:00

Eager load namespace owners for project dashboards

2017-09-11T14:18:59+00:00

This solves an N+1 query problem where we'd run multiple queries when
getting the namespace owners of the displayed projects.

Use a specialized class for querying events

2017-08-10T15:45:49+00:00

This changes various controllers to use the new EventCollection class
for retrieving events. This class uses a JOIN LATERAL query on
PostgreSQL to retrieve queries in a more efficient way, while falling
back to a simpler / less efficient query for MySQL.

The EventCollection class also includes a limit on the number of events
to display to prevent malicious users from cycling through all events,
as doing so could put a lot of pressure on the database.

JOIN LATERAL is only supported on PostgreSQL starting with version 9.3.0
and as such this optimisation is only used when using PostgreSQL 9.3 or
newer.

Eager load project creators for project dashboards

2017-08-07T10:38:33+00:00

This solves an N+1 query problem where for every project we'd query the
creator separately just to figure out what avatar to display.

Enable Style/DotPosition Rubocop :cop:

2017-06-21T13:48:12+00:00

Refactor atom builder by using xml.atom layout

2017-06-12T17:21:13+00:00

Consistently display last push event widget

2017-05-25T20:21:30+00:00

ProjectsFinder should handle more options

2017-04-06T05:11:37+00:00

Extended ProjectFinder in order to handle the following options:
 - current_user - which user use
 - project_ids_relation: int[] - project ids to use
 - params:
   -  trending: boolean
   -  non_public: boolean
   -  starred: boolean
   -  sort: string
   -  visibility_level: int
   -  tags: string[]
   -  personal: boolean
   -  search: string
   -  non_archived: boolean

GroupProjectsFinder now inherits from ProjectsFinder.
Changed the code in order to use the new available options.

Eager load route for project & namespace

2017-03-16T11:31:27+00:00

Use preload for Event#target since it's a polymorphic association

2017-02-13T14:23:23+00:00

Also, don't use limit in subquery, MySQL don't like that.

Signed-off-by: Rémy Coutable