Skip to main content
A
ASailer1-Visitor
1-Visitor
March 8, 2017
Question

Q: Best practice to store attachments of an item?

  • March 8, 2017
  • 2 replies
  • 3631 views

I faced with the question how to add attachments with a size from 100 MB to 200 MB to an item of type "Defect".

I thinking of 2 ways to do this:

  1. Allow the size of the attachment for the ILM (global)
  2. Create a project (configuration management) and add the attachments to this project.

What is the better way to save space in our repository (DB backend)? ...or doesn't it matter in the DB backend?

 

TIA

Alexander Sailer

2 replies

A
acoosemans1-Visitor
1-Visitor
March 8, 2017

Hi Alexander,

We have the same struggle. Attachments are stored in the DB as blobs. This is definitely not good for the performance of the DB. We were told that the current 4MB limit is actually pretty high already.

Unfortunately, we don't have a good alternative.

I believe you need an interface to a document mgmt system where large files can be managed under version control. I am not sure, but maybe a combo of Integrity 11 + Thingworx + Windchill, could do the trick... if you have it.

A
ASailer1-VisitorAuthor
1-Visitor
March 8, 2017

Hello Adriaan,

why use a suggested combo? we got a configuration management system with ILMxxx and so we could use this, can't we?

Kind regards

Alexander Sailer

A
acoosemans1-Visitor
1-Visitor
March 9, 2017

Hello Alexander,

I have no experience with Source Integrity. So I can't say. If that allows you to manage files, it should work, yes.

I know that Windchill stores the metadata in a DB and the actual files on a server. I also know that Integrity for requirements mgmt and test mgmt stores everything in a DB, including attachments. I know that as of Integrity/Windchill 11 the integration between the two should run smoother through Thingworx. But I have no experience with that either.

So we have the same struggle and no proper solution. All I can say is that it does matter for your DB. So your option 1 is not a good idea. And maybe you have an option 3.

M
MichaelChatel5-Regular Member
5-Regular Member
May 8, 2018

FYI, it looks like this product idea was posted, so you may want to cast your votes on it, and add your use-cases, so that product management can see them.

 

File Vaulting for attachments in Workflow&Documents

 https://community.ptc.com/t5/Integrity-Ideas/File-Vaulting-for-attachments-in-Workflow-amp-Documents/idi-p/477761

 

Terms & ConditionsCookie settingsAccessibility statement