-
Richard Mansfield authored
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@catalyst.net.nz>
4b3117e4