Reducing Upgrade Time

If you are upgrading from ListManager 9.1 or 9.1A to any of the ListManager versions from 9.2 to 9.3g, you can reduce upgrade time by creating several indexes while ListManager is still running. These indexes will not be recreated during the upgrade so it will take less time to complete. If you do not create these indexes, the upgrade will create them.

Here are the indexes and SQL statements needed to create them while ListManager is up and running:

MSSQL

Upgrading MSSQL from 9.1

DROP INDEX lyrCompletedRecips.IX_CompletedRecipsMemberID;
CREATE INDEX IX_CompletedRecipsMemberID ON lyrCompletedRecips (MemberID, FinalAttempt, CompletionStatusID, MailingID);

CREATE INDEX IX_lyrMemComplaintLog_MsgID ON lyrMemberComplaintLog (MessageID);

CREATE INDEX IX_members_IsListAdm ON members_ (IsListAdm_, List_);
CREATE INDEX IX_members_List_NotifySubm ON members_ (List_, NotifySubm_);

CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);

Upgrading MSSQL from 9.1a

CREATE INDEX IX_lyrMemComplaintLog_MsgID ON lyrMemberComplaintLog (MessageID);

CREATE INDEX IX_members_IsListAdm ON members_ (IsListAdm_, List_);
CREATE INDEX IX_members_List_NotifySubm ON members_ (List_, NotifySubm_);

CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);

Oracle

Upgrading Oracle from 9.1

DROP INDEX lyrCompletedRecips.IX_CompletedRecipsMemberID;
CREATE INDEX IX_CompletedRecipsMemberID ON lyrCompletedRecips (MemberID, FinalAttempt, CompletionStatusID, MailingID);

CREATE INDEX IX_lyrMemComplaintLog_MsgID ON lyrMemberComplaintLog (MessageID);

CREATE INDEX IX_members_IsListAdm ON members_ (IsListAdm_, List_);
CREATE INDEX IX_members_List_NotifySubm ON members_ (List_, NotifySubm_);
DROP INDEX IX_members_MemberType;
CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);

Upgrading Oracle from 9.1a

CREATE INDEX IX_lyrMemComplaintLog_MsgID ON lyrMemberComplaintLog (MessageID);

CREATE INDEX IX_members_IsListAdm ON members_ (IsListAdm_, List_);
CREATE INDEX IX_members_List_NotifySubm ON members_ (List_, NotifySubm_);

CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);