• Yorick Peterse's avatar
    Revamp finding projects by namespaces · 03417456
    Yorick Peterse authored
    By using a JOIN we can remove the need for using 2 separate queries to
    find a project by its namespace. Combined with an index (only needed for
    PostgreSQL) this reduces the query time from ~245 ms (~520 ms for the
    first call) down to roughly 10 ms (~15 ms for the first call).
    03417456
20151007120511_namespaces_projects_path_lower_indexes.rb 556 Bytes