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

All responses (7)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

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

Amit Thakkar on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

In GP2013 R2 all attachement saved in table "coAttachmentItems"

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

Thanks

Amit
Suggested answer

Amit Thakkar on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

[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]
Jonathan Fear on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

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.
Suggested answer

Tim Foster 8,515 on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

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
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

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
Tsparks 55 on at

Like (0)

Report

RE: Document Attach - GP2013 - Database size

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?