We are no longer offering accounts on this server. Consider https://gitlab.freedesktop.org/ as a place to host projects.

  1. 23 Dec, 2009 7 commits
    • Evan Prodromou's avatar
      Convert Geonames plugin to use XML API instead of JSON · cdc50526
      Evan Prodromou authored
      The XML API for Geonames contains much more detailed error information
      than the JSON one. So, I've converted this plugin to use it instead.
      It seems to be the preferred format for Geonames, so biting the bullet
      on this makes sense.
      cdc50526
    • 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
  2. 21 Dec, 2009 1 commit
  3. 18 Dec, 2009 1 commit
  4. 17 Dec, 2009 4 commits
  5. 16 Dec, 2009 7 commits
  6. 15 Dec, 2009 13 commits
  7. 14 Dec, 2009 7 commits