Reducing upgrade time
When upgrading Aurea List Manager from version 9.1 or 9.1A to any of the Aurea List Manager versions from 9.2 to 9.3g, the upgrade time can be reduced by creating several indexes while Aurea List Manager is still running. These indexes are not recreated during the upgrade, so it takes less time to complete. If you do not create these indexes, the upgrade creates them.
Your database administrator can create these indexes and SQL statements before upgrading Aurea List Manager.
Find below the indexes and SQL statements that are to be created while Aurea List Manager is running on the older version:
For 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_);
For 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_); CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);
Upgrading Oracle from 9.1a
CREATE INDEX IX_lyrMemComplaintLog_MsgID ON lyrMemberComplaintLog (MessageID); (IsListAdm_, List_); CREATE INDEX IX_members_List_NotifySubm ON members_ (List_, NotifySubm_); CREATE INDEX IX_referrals_RecvrMemberID_ ON referrals_ (ReceiverMemberID_);