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-22Skip DB_DataObject's in-process cache for static gets on CLI processes.Brion
The local process cache would grow forever, keeping things stuck in memory and preventing GC.
2009-12-23Merge branch '0.9.x' of git://gitorious.org/statusnet/mainline into 0.9.xSiebrand Mazeland
2009-12-22First version of a CAS authentication pluginCraig Andrews
2009-12-22Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
2009-12-22Ticket 2083: use site.textlimit setting instead of hardcoding 140 into ↵Brion Vibber
documentation
2009-12-22Adjusted notice option alignment in MobileProfileSarven Capadisli
2009-12-21Moving & replacing to the end of html and source dataSarven Capadisli
2009-12-21Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.xSarven Capadisli
2009-12-21Right aligned delete notice option so that when repeat option isSarven Capadisli
present there is a consistent layout
2009-12-21Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
2009-12-21Ticket 1982: define LC_MESSAGES and friends if PHP didn't predefine them for ↵Brion Vibber
us. (Known problem on Win32)
2009-12-21Added admin navigation item to MobileProfileSarven Capadisli
2009-12-20Remove pleonasm in UI textSiebrand Mazeland
2009-12-20Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
* Adding Persian language
2009-12-20Localisation updates for !StatusNet from !translatewiki.net !sntransSiebrand Mazeland
2009-12-19Ignore 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-19Cache the LDAP schema in memcache (if memcache is available)Craig Andrews
2009-12-18Allow caching of ldap schema, greatly improves performance.Eric Helgeson
2009-12-18search->count() doesnt seem to be cached, so we willEric Helgeson
2009-12-18Limit search to only the basedn we're looking inEric Helgeson
2009-12-18Set returnto when redirected to login of a private install (for 0.9.x)Jeffery To
Can't use returnToArgs() because we don't have an action object yet.
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-17Minor styleSarven Capadisli
2009-12-17Merge branch '0.9.x' of git@gitorious.org:statusnet/mainline into 0.9.xSarven Capadisli
2009-12-17Plugin that outputs 'powered by StatusNet' after site nameSarven Capadisli
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-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
generated by cgit v1.2.3-54-g00ecf (git 2.45.2) at 2024-11-07 05:52:46 +0000