delta/gitlab/gitlab-ce.git/app/models/concerns/case_sensitivity.rb, branch refactor-complex-methods gitlab.com: gitlab-org/gitlab-ce.git Revamp finding projects by namespaces 2015-10-08T12:35:32+00:00 Yorick Peterse yorickpeterse@gmail.com 2015-10-07T15:37:39+00:00 03417456f0b7db408bfefd28e5b9342889b7f711 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). 
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).
Added concern for case-insensitive WHERE queries 2015-10-07T21:32:14+00:00 Yorick Peterse yorickpeterse@gmail.com 2015-10-07T12:03:18+00:00 1190d0ab3dc7a3025bf55b666f34d1a0b51a8d89 On PostgreSQL these queries use LOWER(...) to compare columns and values. For MySQL a regular WHERE is performed as MySQL is already case-insensitive. 
On PostgreSQL these queries use LOWER(...) to compare columns and
values. For MySQL a regular WHERE is performed as MySQL is already
case-insensitive.