• Yorick Peterse's avatar
    Precalculate trending projects · 237c8f66
    Yorick Peterse authored
    This commit introduces a Sidekiq worker that precalculates the list of
    trending projects on a daily basis. The resulting set is stored in a
    database table that is then queried by Project.trending.
    
    This setup means that Unicorn workers no longer _may_ have to calculate
    the list of trending projects. Furthermore it supports filtering without
    any complex caching mechanisms.
    
    The data in the "trending_projects" table is inserted in the same order
    as the project ranking. This means that getting the projects in the
    correct order is simply a matter of:
    
        SELECT projects.*
        FROM projects
        INNER JOIN trending_projects ON trending_projects.project_id = projects.id
        ORDER BY trending_projects.id ASC;
    
    Such a query will only take a few milliseconds at most (as measured on
    GitLab.com), opposed to a few seconds for the query used for calculating
    the project ranks.
    
    The migration in this commit does not require downtime and takes care of
    populating an initial list of trending projects.
    237c8f66
schema.rb 53.9 KB