summaryrefslogtreecommitdiff
AgeCommit message (Collapse)Author
2009-12-22Fix 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-22Merge branch 'testing'Evan Prodromou
2009-12-22update to rc2Evan Prodromou
2009-12-22update README for 0.9.0rc2Evan Prodromou
2009-12-21Ignore 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-18Followup 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-17Make useremail.php executableBrion Vibber
2009-12-17Added 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-16Merge branch 'testing' of git@gitorious.org:statusnet/mainline into testingEvan Prodromou
2009-12-16Merge branch '0.9.x' into testing0.9.0rc2Evan Prodromou
2009-12-16Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
2009-12-16Add some doc comments and fixmes in util.phpBrion Vibber
2009-12-16Add doc comments listing the array parameters for User::register() and ↵Brion Vibber
Notice::saveNew()
2009-12-16Fix UserRightsTest unit testsBrion Vibber
2009-12-16PHP 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-16Cleanup 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-16slight cleanup for a bit in Notice.php where a var was reused for different ↵Brion Vibber
types, confusing tracking down a bug
2009-12-15Merge branch '0.9.x' into testingEvan Prodromou
2009-12-15can't repeat your own notice posted through realtimeEvan Prodromou
2009-12-15Don't show repeater avatar in notice listsEvan Prodromou
2009-12-15make realtime plugin grok repeatsEvan Prodromou
2009-12-15Added .form_repeat notice option to received notices in Realtime pluginSarven Capadisli
2009-12-15call DB_DataObject::__destruct() if it existsEvan Prodromou
2009-12-15take out DB_DataObject destructorEvan Prodromou
2009-12-15broadcast for repeatsEvan Prodromou
2009-12-15create a method for notification for new messages, and use itEvan Prodromou
2009-12-15add mail notification for dm command resultsEvan Prodromou
2009-12-15remove dead code for handling direct messages, now done with commandsEvan Prodromou
2009-12-15give some trouble-shooting info for fancy URLsEvan Prodromou
2009-12-14Add 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-14Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.xSarven Capadisli
2009-12-14document logincommand/disabled in READMEEvan Prodromou
2009-12-14default for login command is disabledEvan Prodromou
2009-12-14Initial representation for repeated noticeSarven Capadisli
2009-12-14make sure id of <li> in notice list is uniqueEvan Prodromou
2009-12-14had the order of <status> and <retweeted_status> wrong in api outputEvan Prodromou
2009-12-14Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.xEvan Prodromou
2009-12-14add friends_timeline with no repeats in itEvan Prodromou
2009-12-14fix error with cached repeat of deleted original in api outputEvan Prodromou
2009-12-14Merge branch '0.9.x' of git://gitorious.org/statusnet/mainline into 0.9.xSiebrand Mazeland
2009-12-14move full-featured timeline to apitimelinehome.phpEvan Prodromou
2009-12-14parse error in retweet methodEvan Prodromou
2009-12-14correct link for repeat attribution in noticelistEvan Prodromou
2009-12-14Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
2009-12-14Clean up console output for non-interactive mode (handy for batch setup scripts)Brion Vibber
2009-12-14Fix issue with favorited/following always being set to falseZach Copley
2009-12-14Fix Twitter bridge so it responds reasonably to authorization errors.Zach Copley
2009-12-14Fix issue with favorited/following always being set to falseZach Copley
2009-12-14Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.xZach Copley
2009-12-14Fix Twitter bridge so it responds reasonably to authorization errors.Zach Copley