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
ASailer1-VisitorAuthor
1-Visitor
March 9, 2017

Hello Adriaan,

Source Integrity we have also configured to store files in the DB repository[1] and I'm in doubt of DB performance.

That's why I'm asking here for best practices.

Option 3 has to be created. Any hints or suggestions?

Kind regards

Alexander Sailer

[1] Best practice to have a direct assignment between all parts of a development / process environment without a further tool interface.

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