Hi Axton,

I'm not sure where David posted his reply from my question. When you say 
truncate table, this means that I would directly go to the db to delete records?


 



________________________________
From: Axton <[email protected]>
To: [email protected]
Sent: Tue, December 8, 2009 7:06:37 PM
Subject: Re: safest and fastest way to delete AR Email records

** Look into the sql 'truncate table' to empty it initially.  David has posted 
what you need for the ongoing maintenance of the data.  While doing the initial 
delete, you probably want to look at the email error logs form, the email 
attachments form, and all the other email forms.

Axton


On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden <[email protected]> wrote:

** 
>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"_
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ 




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

Reply via email to