Agile Central: Attachments - What is the impact of large attachment files to performance?

Document ID : KB000100260
Last Modified Date : 06/06/2018
Show Technical Document Details
Introduction:
Agile Central allows including attachments (see link for more info) to many objects and artifacts. 
Question:
Is there an impact on performance if we'll have many attachments of the max size (50MB), even all attached to the same artifact?
Answer:
The short answer is: "No. There is no impact on performance if you have even many file attachments, even to the same object/artifact, even if all are of the max 50MB file size".

The reason lies with how the Attachment object is modeled. This is described in our WSAPI Object Model.
The Attachment object stores the description of the attachment, its name, size, the user who added it, the artifact it belongs to. Yet, it does not contain the actual blob of the file itself. The data blob is stored in another object: "AttachmentContent". The Attachment object also keeps a one-to-one reference to its AttachmentContent.

What this means is that when Agile Central or any of its apps are looking to display whether or not artifacts include attachments, their count, even names or description, even the user who added them, or even the content type - they will not have to query for the actual blob of the file. The data that's kept in the Attachment object is not at all large. Hence the performance will be normal and not be impacted even if many large blobs belong to any artifact or number of artifacts.

The only time the blob is accessed will be when a user is asking to view or download the file. 

As a reference, see some of the details of the Attachment object followed by the AttachmentContent object: 

User-added image
User-added image
User-added image


User-added image
User-added image
Additional Information:
You can see the complete description of the Attachment object in our WSAPI documentation:
https://rally1.rallydev.com/slm/doc/webservice/


Here is supplementary useful information and examples on uploading, deleting and exporting attachments:

- Upload Attachments using WSAPI, see:
https://comm.support.ca.com/kb/upload-attachments-using-web-services-api/kb000047770 

- Delete Attachments, see:
https://comm.support.ca.com/kb/ws-api-questions-about-deleting-attachments-and-attachmentcontent/kb000057532

- Export Attachments, see:
https://comm.support.ca.com/kb/exporting-agile-central-artifact-attachments-and-screenshots/kb000014728