<div dir="ltr">Hi Marc,<div><br></div><div>It's to be expected that SWWCNTP0 is bigger than SWWWIHEAD as the former generally holds a row for every container element while the latter holds a row for every workflow step. Depending on the number of container elements it could be 5x to 10x bigger.</div>
<div><br></div><div>May I ask how you arrived at these table sizes? Using DB02?</div><div><br></div><div>regards</div><div>Rick Bakker</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Oct 2, 2013 at 1:53 PM, CORREIA Marc <span dir="ltr"><<a href="mailto:MCORREIA@goldcoast.qld.gov.au" target="_blank">MCORREIA@goldcoast.qld.gov.au</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div><span><font face="Arial">Hi
all</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">Table SWWCNTP0 is
way bigger than SWWIHEAD in our production SRM system. Can you advise if this is
normal behaviour? Its seems to be considerably larger if you consider
that SWWIHEAD is only 2.9 Gig, yet SWWCNTP0
is </font></span><span><font face="Arial">23
gig.</font></span></div>
<div><span><font face="Arial"> </font></span><span><font face="Arial"></font></span></div>
<div><span><font face="Arial">Can you advise what
strategies could be adopted to manage the size. Is there anything I can do to
help manage the growth, or prevent it somehow? The solution has only been
live for just over a year, so I would not have anticipated the table growing
quite this quickly.</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">Any advice would be
greatly appreciated. The organisation does not have an archiving strategy in
place yet, so for now I don't think that archiving is an option,
</font></span></div>
<div><span><font face="Arial"></font></span> </div>
<div><span><font face="Arial">Regards</font></span><br><br><font><font face="Arial"><b>Marc
Correia</b></font> </font><br><img src="cid:838414503@02102013-08FC" height="3"><br><font face="Arial"><span>Workflow
Developer</span></font></div>
<div align="left"><font face="Arial"><font><span>Service Operations and Support</span> <br>City of
Gold Coast <br><br></font></font><font face="Arial"><font><b>T:</b> 5581 6611 <b>M:</b> 0422 632 696 <br>PO Box 5042 Gold
Coast Mail Centre Qld 9729<br><b><a href="http://www.cityofgoldcoast.com.au/" target="_blank"><font color="#000000">cityofgoldcoast.com.au</font></a></b><br><br><img src="cid:838414503@02102013-0903" height="3"><br><img src="cid:838414503@02102013-090A" width="168" height="42"></font></font></div>
<div> </div>
<p style="margin-top:5pt;margin-bottom:5pt"><span style="font-family:'Arial';font-size:10pt"><b>Tell us about an unsung hero... Nominations are open for City of Gold Coast's 2014 Australia Day Awards. The awards recognise individuals and groups who have made an outstanding contribution to our community.</b></span></p>
<p style="margin-top:5pt;margin-bottom:5pt"><span style="font-family:'Arial';font-size:10pt"><b>Visit <a href="http://cityofgoldcoast.com.au/australiadayawards" target="_blank">cityofgoldcoast.com.au/australiadayawards</a> for information. Nominations close 15 November 2013.</b></span></p>
<p><span style="font-size:10pt;font-family:'Arial'"><b> </b></span></p>
<p><span style="font-family:'Arial';font-size:10pt;color:#0000ff"><b><br>
</b></span><span style="font-size:9pt"><br>
</span></p>
<p><span style="font-family:'Arial';font-size:10pt"><b>Council of the City of Gold Coast / Gold Coast City Council - confidential communication</b></span></p>
<p><span style="font-family:'Arial';font-size:8pt">This email and any files transmitted with it are confidential and are intended solely for the use of the addressee. If you are not the intended recipient be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email and any file attachments is strictly prohibited. If you have received this email in error, please immediately notify us. You must destroy the original transmission and its contents. Before opening or using attachments, check them for viruses and defects. The contents of this email and its attachments may become scrambled, truncated or altered in transmission. Please notify us of any anomalies. Our liability is limited to resupplying the email and attached files or the cost of having them resupplied.</span></p>
<p><span style="font-family:'Arial';font-size:8pt"> </span></p></div>
<br>_______________________________________________<br>
SAP-WUG mailing list<br>
<a href="mailto:SAP-WUG@mit.edu">SAP-WUG@mit.edu</a><br>
<a href="http://mailman.mit.edu/mailman/listinfo/sap-wug" target="_blank">http://mailman.mit.edu/mailman/listinfo/sap-wug</a><br>
<br></blockquote></div><br></div>