This project is mirrored from https://:*****@gitlab.archlinux.org/archlinux/aurweb.git. Pull mirroring updated .
  1. 20 Sep, 2012 2 commits
  2. 19 Sep, 2012 1 commit
  3. 18 Sep, 2012 3 commits
  4. 17 Sep, 2012 2 commits
  5. 23 Aug, 2012 1 commit
  6. 18 Jul, 2012 1 commit
  7. 17 Jul, 2012 1 commit
  8. 15 Jul, 2012 2 commits
  9. 06 Jul, 2012 8 commits
  10. 31 May, 2012 1 commit
  11. 08 Mar, 2012 1 commit
  12. 02 Nov, 2011 1 commit
  13. 25 Oct, 2011 2 commits
  14. 24 Oct, 2011 3 commits
  15. 11 Aug, 2011 5 commits
  16. 25 Jun, 2011 1 commit
    • Dan McGee's avatar
      Use sane ORDER BY clauses in package list queries · 3c110b13
      Dan McGee authored
      
      
      We were doing some silly things here with an "ORDER BY Name, CategoryID"
      clause, due to the fact that Name is unique, and thus any additional
      ordering after Name will have no effect. Of course, the dumb as a box of
      rocks MySQL query optimizer doesn't realize this, leading to full table
      scans every time of ~30000 packages instead of using index scans for the
      ordering and only retrieving the first 50 rows.
      
      The biggest change is noted in the default sort order as it cuts down
      the columns to one, but we can remove the redundant sort from other
      orderings as well, even though those will still not be able to use an
      index-driven query plan.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      3c110b13
  17. 22 Jun, 2011 2 commits
  18. 17 May, 2011 1 commit
  19. 27 Apr, 2011 1 commit
  20. 19 Apr, 2011 1 commit