Document Attach - GP2013 - Database size

(0) Share

Report

Posted on by Tsparks

Everyone have fun at Convergence?!?!

I had one question that nobody at Convergence could answer; maybe someone in the Community knows????

Here's the question. The new Document Attach feature saves the attached documents in a SQL Blog inside the SQL Company DB.

Say a PDF is 1gb and I attach it to the Customer Maintenance card in GP, How much did the size of my SQL server db increase due to the attachment of the 1gb PDF???

Can you see the issue? 1gb Document set to default attach to every transaction created for that Customer. That means that 1gb PDF gets created and saved for every transaction. 50,000 Transactions later, what effect did that 1gb attachment have on the db.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Tsparks 55 on at

Like (0)

Report

I've done some load testing in my environment. It appears as if it's a 1 to 1 relationship. Document is 1gb, DB size increases by 1gb.

Any other findings out there?

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Nothing more valuable to add up.

Same results here. Although, you might be interested in reading the post below;

SQL Server Express database size / BLOB storage

Was this reply helpful? Yes No
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

I asked a Program Manager with Microsoft about using SQL FILESTREAM or RBS at Convergence.

A polite "not at this time" was what I got. Use MS-Connect and post a suggestion - I'd vote for it.

Tim

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

I have never seen a 1 GB PDF file :). With that being said this is a new feature so if you would like to see it changed I would agree with Tim about posting in Connect.

Was this reply helpful? Yes No
Suggested answer

Amit Thakkar on at

Like (0)

Report

[quote user="Tsparks"]

Everyone have fun at Convergence?!?!

I had one question that nobody at Convergence could answer; maybe someone in the Community knows????

Here's the question. The new Document Attach feature saves the attached documents in a SQL Blog inside the SQL Company DB.

Say a PDF is 1gb and I attach it to the Customer Maintenance card in GP, How much did the size of my SQL server db increase due to the attachment of the 1gb PDF???

Can you see the issue? 1gb Document set to default attach to every transaction created for that Customer. That means that 1gb PDF gets created and saved for every transaction. 50,000 Transactions later, what effect did that 1gb attachment have on the db.

[/quote]

Was this reply helpful? Yes No
Suggested answer

Amit Thakkar on at

Like (0)

Report

In GP2013 R2 all attachement saved in table "coAttachmentItems"

in the field name "BinaryBlob" data type varbinary -1

Thanks

Amit

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Just in case you are looking for an attachment report. I have previously developed the following report since it was highly required Attachment Report

Was this reply helpful? Yes No