View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003187 | Composr | core_cns | public | 2017-04-05 13:36 | 2017-07-08 23:44 |
| Reporter | Chris Graham | Assigned To | Chris Graham | ||
| Severity | Feature-request | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Fixed in Version | |||||
| Summary | 0003187: Improve performance for large active communities (very specific) | ||||
| 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 '' | ||||
| Tags | Type: Performance | ||||
| Time estimation (hours) | 0.75 | ||||
| Sponsorship open | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-04-05 13:36 | Chris Graham | New Issue | |
| 2017-04-05 13:36 | Chris Graham | Tag Attached: Type: Performance | |
| 2017-07-08 23:44 | Chris Graham | Status | non-assigned => resolved |
| 2017-07-08 23:44 | Chris Graham | Resolution | open => fixed |
| 2017-07-08 23:44 | Chris Graham | Assigned To | => Chris Graham |
