Pinned topic Working & handling vwattachments
I have seen that the pe db is consumption increase very drastically and i can understand that PE keep a separate copy of document instance.
I have added a sixth step in my workflow that will assign a blank array of attachment but it does not made any effect on the db consumption.
Would you please share any idea/experience, how to handle attachments in this scenario.
DarikSiegfried 060001YENY6 PostsACCEPTED ANSWER
Re: Working & handling vwattachments2014-10-10T02:21:15Z in response to P8World
It sounds like you are able to clear the attachment references in the workflow instance.
An attachment is just a canonical string that contains enough information to retrieve the referenced item. The PE database does not contain any document information, unless the document content is explicitly stored in a String workflow field.
There are various reasons for the PE database to use additional disk space.
- Many active workflow instances with many active work items
- Tracker work items that are not cleaned up
- Event logs that are not pruned