Susan, Can you elaborate on your statement, "I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it."? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: [email protected] Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly brought the server down. I only archive in the lowest of production hours (night) when minimal users are on the system. I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it. Sorry did not get more info. I found the actual archiving to go fairly quick, was doing about 70k records both times. I liked the fact I didn't have to manually delete the records afterwards. hth, Susan ShopperTrak _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
