Changeset 11888 for trunk/src/bp-notifications/bp-notifications-cache.php

Timestamp:

03/05/2018 12:57:24 PM (6 years ago)

Author:

boonebgorges

Message:

Move notification-grouping logic to MySQL.

The notification-grouping logic required to show the collapsed Notifications
toolbar - "You have 3 pending friend requests", etc - is currently done in
PHP, in a manner that requires all notifications to be loaded into memory
and processed. On sites where users have large numbers of notifications, this
operation requires extensive resources. By leaving the grouping to MySQL,
we can speed up processing in almost all situations.

This changeset also adds specific caching for grouped notifications.

Props m_uysl.
See #7130.

File:

• trunk/src/bp-notifications/bp-notifications-cache.php (modified) (1 diff)

trunk/src/bp-notifications/bp-notifications-cache.php

@@ -45 +45 @@
     wp_cache_delete( 'all_for_user_' . $user_id, 'bp_notifications' );
     wp_cache_delete( $user_id, 'bp_notifications_unread_count' );
+    wp_cache_delete( $user_id, 'bp_notifications_grouped_notifications' );
 }