1. 18 Jun, 2009 2 commits
    • Dan McGee's avatar
      Specify explicit joins for package search · 1ceeda8a
      Dan McGee authored
      
      
      Refactor the query to use explicit LEFT JOINs, which appears to be handled
      by MySQL in a saner fashion than the previous implicit join syntax. This is
      part two in a slight fixup for observed slow queries in the production
      environment. With the new indexes and this fixup, a particular iteration of
      this query will examine only 13346 rows instead of 272060.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLoui Chang <louipc.ist@gmail.com>
      1ceeda8a
    • Dan McGee's avatar
      Add multicolumn indexes on votes and notifications tables · e2b3bd1c
      Dan McGee authored
      
      
      To put a long story short, when we do joins on these tables in our
      pkg_search_page() function, we always join on both the user ID and package
      ID columns. By creating multicolumn indices, we can always get the exact row
      we are looking for in the table.
      
      The benefits of adding a unique index should also speak for themselves, as
      we previously did not have this on either of these tables.
      
      This is part one of a two-part series to address the fact that this query
      was often showing up in our slow query logs.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLoui Chang <louipc.ist@gmail.com>
      e2b3bd1c
  2. 13 Apr, 2009 7 commits
  3. 06 Apr, 2009 2 commits
  4. 01 Apr, 2009 1 commit
  5. 12 Mar, 2009 1 commit
  6. 04 Mar, 2009 1 commit
  7. 03 Mar, 2009 6 commits
  8. 02 Mar, 2009 2 commits
  9. 21 Feb, 2009 1 commit
  10. 20 Feb, 2009 1 commit
  11. 19 Feb, 2009 1 commit
  12. 18 Feb, 2009 4 commits
  13. 16 Feb, 2009 1 commit
  14. 15 Feb, 2009 2 commits
  15. 13 Feb, 2009 5 commits
  16. 09 Feb, 2009 1 commit
  17. 06 Feb, 2009 1 commit
  18. 03 Feb, 2009 1 commit