I would write a nice script that deleted the records in blocks of say
50-100k and run it at night. You could test it with a block of 100
during operating hours just to get an idea of the overhead then up to 1k
if things looked good there for another baseline. But then again it
depends on the size of the record too, is there only 10 columns on the
field or 100? Purging 1000 records with 1kb of data will go a lot
smoother than purging 1000 records with 50kb of data.

 

From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Sean Harrodine
Sent: Thursday, November 19, 2009 8:58 AM
To: [email protected]
Subject: Deleting a form with 2 million records

 

** 

Hi all,

 

I need to delete a form and the 2 million records stored in it.

 

Can anyone elighten me please as to the best and safest way to delete
the table with the least amount of impact on the system ie, without
spiking the Oracle archive logs.

 

Is it best to remove some or most of the records by using an ARSPerl
"DeleteEntry" script first, before blowing the form away in the Admin
tool, or is there another way that that i'm not savvy too ?

 

TIA,

Sean

 

_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