Hi David,

Yes, at a database level is another option and access is "available" to me ;o)

Presumably then, its just a quick visit to the admin tool to remove the form 
then afterwards and any workflow ???

rgds,
Sean




________________________________
From: David Morgan <[email protected]>
To: [email protected]
Sent: Thu, 19 November, 2009 15:14:50
Subject: Re: Deleting a form with 2 million records

Hi Sean

Is it possible to access it via the database and use :-
    truncate table Txxx ; 
    truncate table Bxxx ; 
    truncate table Hxxx ;

where xxx is the schemaid of the table (select name, schemaid from
arschema where name = 'FORM NAME';)

so as to empty the records therein, before deleting the form?
That's probably the quickest way. 

Regards
Dave Morgan


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Tommy Morris
Sent: 19 November 2009 15:09
To: [email protected]
Subject: Re: Deleting a form with 2 million records

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA692A.3580FDC6
Content-Type: text/plain;
    charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.

=20

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

=20

**=20

Hi all,

=20

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

=20

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.

=20

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 ?

=20

TIA,

Sean

=20

_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"

------_=_NextPart_001_01CA692A.3580FDC6
Content-Type: text/html;
    charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

**
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema"
=
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spreadsheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40"; =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/"; =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing"; =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/"; =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/meetings/"; =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/xml"; =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd"; =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/ois/"; =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/directory/"; =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#"; =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp"; =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc"; =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema"; =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/
"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"; =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/"; =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/"; =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"; =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap"; =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile"; =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/parttopart"; =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/"; =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsig-setup"; =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsig"; =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/2006/digital-si
g=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compatibility/200
6=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"; =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/2006/relationsh
i=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages"; =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/services/2006/types
"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/services/2006/messa
g=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary
/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPortalServer/Pu
b=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40";>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
    {font-family:Tahoma;
    panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0in;
    margin-bottom:.0001pt;
    font-size:12.0pt;
    font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:blue;
    text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:purple;
    text-decoration:underline;}
span.EmailStyle17
    {mso-style-type:personal-reply;
    font-family:"Calibri","sans-serif";
    color:#1F497D;}
.MsoChpDefault
    {mso-style-type:export-only;
    font-size:10.0pt;}
@page Section1
    {size:8.5in 11.0in;
    margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
    {page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0in 0in 0in'>

<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span
>=
</b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Action =
Request
System discussion list(ARSList) [mailto:[email protected]] <b>On =
Behalf Of </b>Sean
Harrodine<br>
<b>Sent:</b> Thursday, November 19, 2009 8:58 AM<br>
<b>To:</b> [email protected]<br>
<b>Subject:</b> Deleting a form with 2 million =
records<o:p></o:p></span></p>

</div>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>** <o:p></o:p></p>

<div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Hi
all,<o:p></o:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;<o:p></
o=
:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>I&nbsp;need
to delete a form and the&nbsp;2 million records stored in =
it.<o:p></o:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;<o:p></
o=
:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>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.<o:p></o:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;<o:p></
o=
:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Is
it best to remove some or most of the records by using an ARSPerl
&quot;DeleteEntry&quot; script first, before blowing the form away in =
the Admin
tool, or is there another way that that i'm not savvy too =
?<o:p></o:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>&nbsp;<o:p></
o=
:p></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>TIA,<o:p></o:
p=
></span></p>

</div>

<div>

<p class=3DMsoNormal><span =
style=3D'font-size:8.0pt;font-family:"Arial","sans-serif"'>Sean<o:p></o:
p=
></span></p>

</div>

</div>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal>_Platinum Sponsor: [email protected] =
ARSlist:
&quot;Where the Answers Are&quot;_<o:p></o:p></p>

</div>

</body>

</html>
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_

------_=_NextPart_001_01CA692A.3580FDC6--

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
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