SWWCNTP0 very large compared to SWWIHEAD

[Rick Bakker]

Hi Marc,

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.

May I ask how you arrived at these table sizes? Using DB02?

regards
Rick Bakker


On Wed, Oct 2, 2013 at 1:53 PM, CORREIA Marc
<MCORREIA at goldcoast.qld.gov.au>wrote:

> **
> Hi all
>
> 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 23
> gig.
>
> 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.
>
> 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,
>
> Regards
>
> *Marc Correia*
>
> Workflow Developer
> Service Operations and Support
> City of Gold Coast
>
> *T:* 5581 6611 *M:* 0422 632 696
> PO Box 5042 Gold Coast Mail Centre Qld 9729
> *cityofgoldcoast.com.au <http://www.cityofgoldcoast.com.au/>*
>
>
>
>
> *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.*
>
> *Visit cityofgoldcoast.com.au/australiadayawards for information.
> Nominations close 15 November 2013.*
>
> * *
>
> *
> *
>
> *Council of the City of Gold Coast / Gold Coast City Council -
> confidential communication*
>
> 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.
>
>
>
> _______________________________________________
> SAP-WUG mailing list
> SAP-WUG at mit.edu
> http://mailman.mit.edu/mailman/listinfo/sap-wug
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20131004/8c391631/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 150 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20131004/8c391631/attachment.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 6498 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20131004/8c391631/attachment-0001.png
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 150 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20131004/8c391631/attachment-0002.png