Age | Commit message (Collapse) | Author | |
---|---|---|---|
2009-12-22 | Fix for massively slow friends timeline query due to indexing bug introduced ↵ | Brion Vibber | |
with repeats. 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 | +----+-------------+--------------+--------+------------------------------------+---------+---------+-------------------------------+--------+--------------------------+ | |||
2009-12-22 | Merge branch 'testing' | Evan Prodromou | |
2009-12-22 | update to rc2 | Evan Prodromou | |
2009-12-22 | update README for 0.9.0rc2 | Evan Prodromou | |
2009-12-21 | Ignore user language settings that aren't listed in language config; we'll ↵ | Brion Vibber | |
then fall back to current autodetection. This prevents the surprises where your profile suddenly switches to Arabic because it was selected by default due to lack of a match in the drop-down box. | |||
2009-12-18 | Followup fix for ticket 1672: Twitter bridge !group->#hash conversion will ↵ | Brion Vibber | |
now happen regardless of whether account was configured with oauth or basic auth (previously applied only on the oauth path) | |||
2009-12-17 | Make useremail.php executable | Brion Vibber | |
2009-12-17 | Added UserEmail script. | Christopher Vollick | |
Used to query user's emails. Mostly used for administration, to see if a user requesting something is who they say. Also, some people assume that the admin knows this data, and says things like: "If you could do _____ with the account connected to this email". It'd be nice if we could do that without raw SQL. | |||
2009-12-16 | Merge branch 'testing' of git@gitorious.org:statusnet/mainline into testing | Evan Prodromou | |
2009-12-16 | Merge branch '0.9.x' into testing0.9.0rc2 | Evan Prodromou | |
2009-12-16 | Localisation updates for !StatusNet from !translatewiki.net !sntrans | Siebrand Mazeland | |
2009-12-16 | Add some doc comments and fixmes in util.php | Brion Vibber | |
2009-12-16 | Add doc comments listing the array parameters for User::register() and ↵ | Brion Vibber | |
Notice::saveNew() | |||
2009-12-16 | Fix UserRightsTest unit tests | Brion Vibber | |
2009-12-16 | PHP 5.3 closure-based implementation of curry(); old implementation used as ↵ | Brion Vibber | |
fallback for older PHP versions. Added unit tests to confirm they both work! | |||
2009-12-16 | Cleanup undefined variable notice: set a couple more null defaults for new ↵ | Brion Vibber | |
params in Notice::saveNew(). Fixes this notice seen while using AJAX repeat button: Notice: Undefined variable: uri in classes/Notice.php on line 243 | |||
2009-12-16 | slight cleanup for a bit in Notice.php where a var was reused for different ↵ | Brion Vibber | |
types, confusing tracking down a bug | |||
2009-12-15 | Merge branch '0.9.x' into testing | Evan Prodromou | |
2009-12-15 | can't repeat your own notice posted through realtime | Evan Prodromou | |
2009-12-15 | Don't show repeater avatar in notice lists | Evan Prodromou | |
2009-12-15 | make realtime plugin grok repeats | Evan Prodromou | |
2009-12-15 | Added .form_repeat notice option to received notices in Realtime plugin | Sarven Capadisli | |
2009-12-15 | call DB_DataObject::__destruct() if it exists | Evan Prodromou | |
2009-12-15 | take out DB_DataObject destructor | Evan Prodromou | |
2009-12-15 | broadcast for repeats | Evan Prodromou | |
2009-12-15 | create a method for notification for new messages, and use it | Evan Prodromou | |
2009-12-15 | add mail notification for dm command results | Evan Prodromou | |
2009-12-15 | remove dead code for handling direct messages, now done with commands | Evan Prodromou | |
2009-12-15 | give some trouble-shooting info for fancy URLs | Evan Prodromou | |
2009-12-14 | Add destructor on Memcached_DataObject to free DB_DataObject's global ↵ | Brion Vibber | |
storage for an object when that object itself is destroyed. Reduces some, but not all, memory leakage for long-running processes. | |||
2009-12-14 | Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.x | Sarven Capadisli | |
2009-12-14 | document logincommand/disabled in README | Evan Prodromou | |
2009-12-14 | default for login command is disabled | Evan Prodromou | |
2009-12-14 | Initial representation for repeated notice | Sarven Capadisli | |
2009-12-14 | make sure id of <li> in notice list is unique | Evan Prodromou | |
2009-12-14 | had the order of <status> and <retweeted_status> wrong in api output | Evan Prodromou | |
2009-12-14 | Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.x | Evan Prodromou | |
2009-12-14 | add friends_timeline with no repeats in it | Evan Prodromou | |
2009-12-14 | fix error with cached repeat of deleted original in api output | Evan Prodromou | |
2009-12-14 | Merge branch '0.9.x' of git://gitorious.org/statusnet/mainline into 0.9.x | Siebrand Mazeland | |
2009-12-14 | move full-featured timeline to apitimelinehome.php | Evan Prodromou | |
2009-12-14 | parse error in retweet method | Evan Prodromou | |
2009-12-14 | correct link for repeat attribution in noticelist | Evan Prodromou | |
2009-12-14 | Localisation updates for !StatusNet from !translatewiki.net !sntrans | Siebrand Mazeland | |
2009-12-14 | Clean up console output for non-interactive mode (handy for batch setup scripts) | Brion Vibber | |
2009-12-14 | Fix issue with favorited/following always being set to false | Zach Copley | |
2009-12-14 | Fix Twitter bridge so it responds reasonably to authorization errors. | Zach Copley | |
2009-12-14 | Fix issue with favorited/following always being set to false | Zach Copley | |
2009-12-14 | Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.x | Zach Copley | |
2009-12-14 | Fix Twitter bridge so it responds reasonably to authorization errors. | Zach Copley | |