View Issue Details

Jump to NotesJump to HistorySearch commits
IDProjectCategoryView StatusDate SubmittedLast Update
0003186Composrcore_cnspublic2017-04-05 13:332017-07-08 23:05
ReporterChris GrahamAssigned ToChris Graham 
SeverityFeature-request 
Status resolvedResolutionfixed 
Product Version 
Fixed in Version 
Summary0003186: Improve member merge performance
DescriptionFor member merge to work with good performance many new indexes will be needed.

$GLOBALS['FORUM_DB']->create_index('f_posts', 'last_edit_by', array('p_last_edit_by'));
$GLOBALS['FORUM_DB']->create_index('f_invites', 'inviter', array('i_inviter'));
$GLOBALS['FORUM_DB']->create_index('f_poll_votes', 'member_id', array('pv_member_id'));
$GLOBALS['SITE_DB']->create_index('digestives_tin', 'from_member_id', array('d_from_member_id'));
$GLOBALS['SITE_DB']->create_index('stats', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('cache', 'the_member', array('the_member'));
$GLOBALS['SITE_DB']->create_index('ticket_known_emailers', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('searches_saved', 'member_id', array('s_member_id'));
$GLOBALS['SITE_DB']->create_index('searches_logged', 'member_id', array('s_member_id'));
$GLOBALS['SITE_DB']->create_index('quiz_entries', 'member', array('q_member'));
$GLOBALS['SITE_DB']->create_index('quiz_member_last_visit', 'member_id', array('v_member_id'));
$GLOBALS['SITE_DB']->create_index('w_messages', 'destination', array('destination'));
$GLOBALS['SITE_DB']->create_index('w_messages', 'originator_id', array('originator_id'));
$GLOBALS['SITE_DB']->create_index('rating', 'rating_member', array('rating_member'));
$GLOBALS['SITE_DB']->create_index('logged_mail_messages', 'm_as', array('m_as'));
$GLOBALS['SITE_DB']->create_index('link_tracker', 'member_id', array('c_member_id'));
$GLOBALS['SITE_DB']->create_index('wiki_posts', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('booking', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('banner_clicks', 'member_id', array('c_member_id'));
$GLOBALS['SITE_DB']->create_index('ecom_sales', 'memberid', array('memberid'));
$GLOBALS['SITE_DB']->create_index('calendar_events', 'member_calendar', array('e_member_calendar'));
$GLOBALS['SITE_DB']->create_index('calendar_jobs', 'member_id', array('j_member_id'));
$GLOBALS['SITE_DB']->create_index('chargelog', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('chat_messages', 'member_id', array('member_id'));
$GLOBALS['SITE_DB']->create_index('calendar_reminders', 'member_id', array('n_member_id'));
TagsType: Performance
Time estimation (hours)1.5
Sponsorship open

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-04-05 13:33 Chris Graham New Issue
2017-04-05 13:33 Chris Graham Tag Attached: Type: Performance
2017-07-08 23:05 Chris Graham Status non-assigned => resolved
2017-07-08 23:05 Chris Graham Resolution open => fixed
2017-07-08 23:05 Chris Graham Assigned To => Chris Graham