#3187 - Improve performance for large active communities (very specific)

Identifier #3187
Issue type Feature request or suggestion
Title Improve performance for large active communities (very specific)
Status Completed
Tags

Type: Performance (custom)

Handling member Chris Graham
Addon core_cns
Description Adding these indexes will fix some small-to-moderate performance issues with large numbers of attachments/members/notifications-enabled.

$GLOBALS['FORUM_DB']->create_index('f_members', 'last_visit_time_2', array('m_last_visit_time'));
$GLOBALS['SITE_DB']->create_index('attachment_refs', 'attachmentreferences', array('r_referer_type', 'r_referer_id'));
$GLOBALS['SITE_DB']->create_index('notifications_enabled', 'who_has', array('l_notification_code', 'l_code_category(10)', 'l_setting')); // l_code_category is not enough as may be searched as ''
Steps to reproduce

Funded? No
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated