• Log graph

Commits in ~brion/statusnet/brion-fixes:sorting

• Saturday December 18 2010

  • 01:22

    

    brion committed 5300d65

    Sort indexing fix for profile sidebar: add group_member_profile_id_created_idx to group_member table, streamlines sorting of your group memberships in the sidebar

  • 01:21

    

    brion committed c066996

    fix typo in showstream

  • 01:12

    

    brion committed 146d6b8

    Sorting index fix for role lookups: adds profile_role_role_created_profile_id_idx index on profile_role

  • 01:08

    

    brion committed fb65d59

    Update sorting for conversation views: adds notice_conversation_created_id_idx index on notice, replacing more limited notice_conversation_idx

  • 00:28

    

    brion committed 71151b3

    Update sorting for User::repeatedByMe() -- currently unused. Likely not ideally indexed yet.

  • 00:25

    

    brion committed b801512

    Update sorting on api/statuses/retweets_of_me; was and remains poorly indexed, but will use updated sorting method.

  • 00:13

    

    brion committed 1b90ed5

    Update sorting on api/statuses/retweets: adds notice_repeat_of_created_id_idx index to replace notice_repeatof_idx

  • 00:05

    

    brion committed 04aa8bd

    work around borkage in statuses/repeats -- tries to check an offset var that's not there. use the limit var which is there instead

• Friday December 17 2010

  • 23:51

    

    brion committed 6647458

    Update sorting for group inbox timelines; adds group_inbox_group_id_created_notice_id_idx index to group_inbox table

  • 23:43

    

    brion committed 3ddfa4d

    Update sorting on reply/mentions timeline: added reply_profile_id_modified_notice_id_idx index to reply table

  • 23:37

    

    brion committed 00a5a53

    Update sorting for tag-filtered public timeline: needs notice_tag_tag_created_notice_id_idx index added to notice_tag

  • 23:32

    

    brion committed 33daace

    add fixme for since_id/max_id on fave streaming (?)

  • 22:45

    

    brion committed 4adf551

    Update sorting for user tagged timelines (indexing was bad before and remains bad -- we need some DB changes to make this one nice)

  • 22:20

    

    brion committed 4cd3a07

    Update notice sorting for profile streams; extract more common code to Notice::addSinceId() and Notice::addMaxId()

  • 22:03

    

    brion committed 9e8bbff

    Notice::whereSinceId() and Notice::whereMaxId() encapsulate logic for building where clauses for since_id/max_id parameters. Can override the field names from 'id' and 'created'.

  • 21:49

    

    brion committed 53dd258

    Switch public timeline to new sorting; new index notice_created_id_is_local_idx

  • 21:38

    

    brion committed 5de86f0

    Initial switch of public timeline stream to use timestamps for internal sorting

  • 21:09

    

    brion committed 7c84c35

    Notice::getAsTimestamp() static function to look up the timestamp for a given notice, even if it's been deleted. To be used for converting since_id/max_id processing to use timestamp sorting internally.

  • 21:08

    

    brion committed 0e7a283

    only run explain on selects

  • 20:46

    

    brion committed 0535a3d

    Event hook for SQLProfile

  • 20:41

    

    brion committed 66b89de

    SQLProfile: quickie plugin to run DB queries through 'explain' and log ones that trigger filesort or temporary table

  • 05:13

    

    zcopley committed 446c2ab

    Document a few undocumented administration related events

  • 02:02

    

    brion committed 46d9496

    Tickets #2112, 2333, 1677, 2362, 2831: fix AJAX form posting on SSL page views with ssl=sometimes

  • 01:18

    

    brion committed 532178e

    Fix for ticket #2910: fix inconsistencies in notice posting response display that broke help command, could be generally wonky

  • 00:34

    

    brion committed f901c25

    Add lots of doc comments to util.js. Most stuff makes some kind of stuff, but some is kinda.... funky :D

  • 00:04

    

    brion committed 364bc6e

    work in progress

• Thursday December 16 2010

  • 22:42

    

    brion committed ed24c95

    Fix ticket #2929: router cache now clears itself when switching singleuser mode in and out

  • 19:38

    

    brion committed ba2b670

    add .mo files to .gitignore

  • 16:33

    

    siebrand committed ae65f93

    L10n updates and removal of superfluous whitespace.

  • 16:30

    

    siebrand committed cf82462

    Localisation updates from http://translatewiki.net.