mahara-contributors team mailing list archive

[Mahara Bot <854403@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/870
Committed: http://gitorious.org/mahara/mahara/commit/4b3117e421cea1252d2c36d9104d16abb37237e4
Submitter: Richard Mansfield (richardm@xxxxxxxxxx)
Branch:    master

commit 4b3117e421cea1252d2c36d9104d16abb37237e4
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Tue Nov 15 11:04:30 2011 +1300

    Add column for unread message counts to the usr table (bug #854403)
    
    The unread message counts are expensive to query in postgres when
    notification_internal_activity gets big.  This results in very slow
    logins (the first time the query is run).  This patch adds a new
    column for each user to store the unread message count.
    
    The counts are updated using a trigger on insert, update and delete
    of the notification_internal_activity table.
    
    Change-Id: Ifb24c6892567658584f45825437bb7a8f20cc310
    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