1. 29 Dec, 2015 1 commit
  2. 18 Dec, 2015 1 commit
  3. 16 Dec, 2015 1 commit
  4. 15 Dec, 2015 1 commit
  5. 12 Dec, 2015 1 commit
  6. 11 Dec, 2015 4 commits
  7. 10 Dec, 2015 1 commit
  8. 09 Dec, 2015 1 commit
  9. 07 Dec, 2015 1 commit
  10. 25 Nov, 2015 1 commit
  11. 19 Nov, 2015 1 commit
  12. 18 Nov, 2015 4 commits
  13. 17 Nov, 2015 1 commit
  14. 16 Nov, 2015 1 commit
  15. 13 Nov, 2015 1 commit
  16. 05 Nov, 2015 2 commits
  17. 04 Nov, 2015 1 commit
  18. 03 Nov, 2015 3 commits
  19. 27 Oct, 2015 1 commit
  20. 21 Oct, 2015 2 commits
  21. 20 Oct, 2015 1 commit
  22. 14 Oct, 2015 2 commits
  23. 08 Oct, 2015 1 commit
    • Yorick Peterse's avatar
      Revamp finding projects by namespaces · 369cc6c06c90
      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).
      369cc6c06c90
  24. 06 Oct, 2015 1 commit
    • Yorick Peterse's avatar
      Revamp trending projects query · fd1c2ecb6709
      Yorick Peterse authored
      This changes the query to use a COUNT nested in an INNER JOIN, instead
      of a COUNT plus a GROUP BY. There are two reasons for this:
      
      1. Using a COUNT in an INNER JOIN can be quite a bit faster.
      2. The use of a GROUP BY means that method calls such as "any?"
         (and everything else that calls "count") operate on a Hash that
         counts the amount of notes on a per project basis, instead of just
         counting the total amount of projects.
      
      The query has been moved into Project.trending as its logic is simple
      enough. As a result of this testing the TrendingProjectsFinder class
      simply involves testing if the right methods are called, removing the
      need for setting up database records.
      fd1c2ecb6709
  25. 05 Oct, 2015 1 commit
  26. 03 Oct, 2015 1 commit
  27. 02 Oct, 2015 1 commit
  28. 01 Oct, 2015 1 commit
  29. 29 Sep, 2015 1 commit