HI Gabud,

Why not use the Archive feature on the Email Messages form?  In the form set 
the Archive Type to "Delete from Source" and set a time like an escalation. In 
a case like this (3M records) first I find the date of the first record (e.g. 9 
Dec 2007) and set up the qualification as 'Create Date' < (60*60*24*705). This 
is two years minus 25 days. Each day after the archive has run I subtract 
another 25-30 days until I get to the desired number of days which for me is 3 
days. Nothing special about the 25-30 days, just like to do small batches. Once 
you get down to the desired level of days, you can almost forget that it runs.

You can run the Archive more then once a day but no less than once an hour. 
Archive won't start if the previous Archive is still running.

FYI
Mark

________________________________
From: Action Request System discussion list(ARSList) 
[mailto:[email protected]] On Behalf Of Ex Soundgarden
Sent: Tuesday, December 08, 2009 6:57 PM
To: [email protected]
Subject: safest and fastest way to delete AR Email records

Hi All,

I've been wandering around searching for some tips on how to delete 3 million 
records sitting in AR System Email Messages form. What I''m doing right now is 
just doing it by batch - deleting 10,000 records every now and then. From the 
past, I remember doing it directly in the database by re-creating the Email 
Messages table (which eventually dropped all the records). I had no problem 
with this.

I just want to know if there are other ways to delete the records without going 
directly to the db?

Thanks,
Gabud


_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the 
person or entity to which it is addressed and may contain information that is 
privileged, confidential, or otherwise protected from disclosure. Distribution 
or copying of this e-mail, or the information contained herein, to anyone other 
than the intended recipient is prohibited.

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to