Assuming you're planning to delete ALL the data in each of these forms, I agree with Ken & Fred: using TRUNCATE TABLE is the only way to go.
If you only want to selectively delete data, well, that's going to be a lot more painful though you still may want to consider using SQL (DELETE FROM) for the operation and carefully construct the WHERE clauses for each of the relevant tables. Deleting 160 million entries through ARS will take forever and would be the least attractive option to me. Either way, absolutely coordinate this with your DBA's as this kind of operation, and the magnitude of the data, will certainly have impact on things like transaction logs. -charlie On Thu, Jan 9, 2014 at 1:02 PM, Grooms, Frederick W < [email protected]> wrote: > ** > > We do it with a truncate table SQL command (since we want to delete > everything) > > Simply find your schema ID for the form in question and Truncate the T, H, > and B tables for that ID > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Cecil, Ken > *Sent:* Thursday, January 09, 2014 2:58 PM > *To:* [email protected] > > *Subject:* Cleaning up forms before migration > > > > ** > > We have some backend forms with large amounts of data that we don’t care > about and would like to delete before doing a data migration. > > > > For example FB:History has over 160 million records. What is the best way > to go about deleting data out of the forms that have gotten away from us. > > > > I know we should have set up escalations or archiving to prevent this. > > > > Obviously deleting them through search and delete is out of the question. > If I set up an escalation to do it I think it would kill performance or > take forever. How do you guys go about it. Risky SQL? > > > > Thanks, > > > > Ken Cecil > > > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
