1. 28 Dec, 2009 14 commits
  2. 27 Dec, 2009 2 commits
  3. 24 Dec, 2009 3 commits
  4. 23 Dec, 2009 7 commits
    • Evan Prodromou's avatar
    • Evan Prodromou's avatar
      15b9f618
    • Evan Prodromou's avatar
      save location at notice post time · 725b2d04
      Evan Prodromou authored
      725b2d04
    • Brion Vibber's avatar
      Fix for massively slow friends timeline query due to indexing bug introduced with repeats. · fa0fbd01
      Brion Vibber authored
      Sorting on notice.id when our primary selector was notice_inbox.user_id caused a filesort and table scan of the notice table.
      Switchng to notice_inbox's notice_id means we can use our index, and everything comes right up.
      
      Before:
      mysql> explain SELECT notice.id AS id FROM notice JOIN notice_inbox ON notice.id = notice_inbox.notice_id WHERE notice_inbox.user_id = 18574 AND notice.repeat_of IS NULL ORDER BY notice.id DESC LIMIT 61 OFFSET 0;
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+----------------------------------------------+
      | id | select_type | table        | type   | possible_keys                      | key     | key_len | ref                           | rows   | Extra                                        |
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+----------------------------------------------+
      |  1 | SIMPLE      | notice_inbox | ref    | PRIMARY,notice_inbox_notice_id_idx | PRIMARY | 4       | const                         | 102600 | Using index; Using temporary; Using filesort |
      |  1 | SIMPLE      | notice       | eq_ref | PRIMARY                            | PRIMARY | 4       | stoica.notice_inbox.notice_id |      1 | Using index                                  |
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+----------------------------------------------+
      
      After:
      mysql> explain SELECT notice.id AS id FROM notice JOIN notice_inbox ON notice.id = notice_inbox.notice_id WHERE notice_inbox.user_id = 18574 AND notice.repeat_of IS NULL ORDER BY notice_id DESC LIMIT 61 OFFSET 0;
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+--------------------------+
      | id | select_type | table        | type   | possible_keys                      | key     | key_len | ref                           | rows   | Extra                    |
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+--------------------------+
      |  1 | SIMPLE      | notice_inbox | ref    | PRIMARY,notice_inbox_notice_id_idx | PRIMARY | 4       | const                         | 102816 | Using where; Using index |
      |  1 | SIMPLE      | notice       | eq_ref | PRIMARY,notice_repeatof_idx        | PRIMARY | 4       | stoica.notice_inbox.notice_id |      1 | Using where              |
      +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+--------------------------+
      fa0fbd01
    • Evan Prodromou's avatar
      Merge branch 'testing' · f6bf9529
      Evan Prodromou authored
      f6bf9529
    • Evan Prodromou's avatar
      update to rc2 · 30c2e2ce
      Evan Prodromou authored
      30c2e2ce
    • Evan Prodromou's avatar
      update README for 0.9.0rc2 · d708e40b
      Evan Prodromou authored
      d708e40b
  5. 21 Dec, 2009 1 commit
  6. 18 Dec, 2009 1 commit
  7. 17 Dec, 2009 4 commits
  8. 16 Dec, 2009 7 commits
  9. 15 Dec, 2009 1 commit