SWWCNTP0 very large compared to SWWIHEAD

[Kjetil Kilhavn]

Fredag 4. oktober 2013 08.20.41 skrev CORREIA Marc:
> Hi I send this through but it has not been posted, can you tell me why
> please?
It was posted - and you even received two replies.
One from Rick Bakker explaining why you could expect SWWCNTP0 to be several 
times bigger than SWWIHEAD (and also wondering how you found the table sizes).
Another one from Eddie Morris pointing you to OSS Note 1552169.

Now the question is: will you receive this message twice? Once as a copy 
recipient and once from the mailing list. If you don't you are not receiving 
messages from the mailing list and I would suspect you need to talk to whoever 
is responsible for your e-mail server.

> 
> Thanks
> Marc.
> 
> ________________________________
> From: CORREIA Marc
> Sent: Wednesday, 2 October 2013 1:53 PM
> To: 'sap-wug at mit.edu'
> Subject: SWWCNTP0 very large compared to SWWIHEAD
> 
> 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
-- 
Kjetil Kilhavn / Vettug AS (http://www.vettug.no)