An error occurred fetching the project authors.
- 08 Oct, 2015 1 commit
-
-
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).
-
- 07 Oct, 2015 1 commit
-
-
Yorick Peterse authored
On PostgreSQL these queries use LOWER(...) to compare columns and values. For MySQL a regular WHERE is performed as MySQL is already case-insensitive.
-