We already have an SRM system in production storing many large attachments on table BBPCONT.
We are facing huge performance problems because:
a) SRM holds the whole file content in memory during document upload.
b) During the process of saving the document, SRM creates one record in VBDATA table for each row that will be stored in BBPCONT. For large files, this process of inserting data at VBDATA takes a very long runtime.
I have two questions:
1) Anyone already handled this situation ?
2) We are thinking about using an external content server to store attachments. My concern is related to the attachments already stored at BBPCONT. Will these documents be available to the user or it is necessary to build conversion programs to move attachments from BBPCONT to the external server ?