Redesign attachments handling in Service Manager

Redesign attachments handling in Service Manager

Storing attachments in SYSATTACHEMNTS table of db is legacy approach inherited from SC on P4, it has its pros and cons, but at least for some customers the current attachment's handling method isn't optimal it terms of extensive using of large attachment files within SM modules.

Extensive work with attachments of 30-100M size will generate significant traffic between SM RTE and Database which will affect the performance of routine end user's operations. The other limitation of current design is scalability, for most of customers SYSATTACHMENTS is the largest table in SM Database and it require additional efforts to maintain it properly, - keep separate datafiles, estimate DB size growth per time to have available disk space resources, etc.

One of possible solutions for attachments can be files storing in configurable FTP server but the simplfied infomation (including file storing location) can be stored in DB still.

Same enhancement request is available per this link.

Tags (2)
3 Comments
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes
 
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: New Idea

The requirement of moving attachment files from table sysattachment to a file server implies a big data structure and workflow change. The change is required on RTE,  Client and Applications. The effort size of this implementation is huge and will have a big impact when customer do upgrade. Based on the fact, this idea will not be considered in SM roadmap

Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Declined
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.