mahara-contributors team mailing list archive

[Mahara Bot <854403@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/871
Committed: http://gitorious.org/mahara/mahara/commit/60167828f1fa2d1e225dd61099fcc2915ebe8a90
Submitter: Richard Mansfield (richardm@xxxxxxxxxx)
Branch:    master

commit 60167828f1fa2d1e225dd61099fcc2915ebe8a90
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Tue Nov 15 11:10:22 2011 +1300

    Get unread message count from user table (bug #854403)
    
    Also keeps the count in the $USER object up to date whenever the
    user deletes or reads a notification.
    
    When new notifications are generated for a live user by another user,
    or on cron, the logged-in user's unread count is reloaded from the
    database into the session either on hitting the inbox, or whenever
    $USER is committed for some other reason.
    
    The code to reload the background fields on commit of the LiveUser
    object has been changed to ensure that it still works at upgrade time,
    where the 'reload' column doesn't exist in the user table yet, but
    *does* exist in the User object.
    
    Change-Id: I9c9a81bf77d0927352902dee0d989d6122757b47
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/854403

Title:
  Unread notification count is too slow

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  Fetching the count of unread notifications to sit next to the envelope
  in the header is expensive on postgres, because
  notification_internal_activity is the biggest table.  It's also rather
  unnecessary, so we should add an option to remove the count, and at
  the same time use a different envelope icon whenever the user has more
  than one unread notification.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/854403/+subscriptions