#3186 - Improve member merge performance

Identifier #3186
Issue type Feature request or suggestion
Title Improve member merge performance
Status Completed
Tags

Type: Performance (custom)

Handling member Chris Graham
Addon core_cns
Description For 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'));
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