Mahara

  1. Bug #854403
  2. Comment #3

Comment 3 for bug 854403

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/870
Committed: http://gitorious.org/mahara/mahara/commit/4b3117e421cea1252d2c36d9104d16abb37237e4
Submitter: Richard Mansfield (<email address hidden>)
Branch: master

commit 4b3117e421cea1252d2c36d9104d16abb37237e4
Author: Richard Mansfield <email address hidden>
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 <email address hidden>