You are viewing limited content. For full access, please sign in.

Question

Question

documents effect on database size

asked on March 7, 2014

 

We currently have SQL express 2008 R2. The business would like to start archiving their emails in laserfiche. I know that the database only stores Metadata and image points but how big is that information? I basically would like to know how many emails can be stored in 1GB of the database file.

0 0

Answer

APPROVED ANSWER
replied on March 7, 2014 Show version history

There's a couple of things you'll want to take into account.

 

First, you need to add folders into the mix. Each folder has a row in the database that is in fact in the same table as the documents. Documents are just nodes that can't have children. Any shortcuts are also going to have a row. Electronic documents are going to generate rows in the Docs (pages) table. I don't know what the rules are. It seems to create multiple pages, but I don't know what the split criteria is.

 

Next, you'll need to consider metadata. The size of the metadata depends on how many fields that you have in the templates.

 

In our repository we've got about 1.6 million Tocs (that's the table that holds documents, folders, and shortcuts) all with templates and varying numbers of fields. The repository database is approximately 11.4GB. Unless I messed up my math (hey, it's Friday) that equates to about 10.7KB per Toc and in the end a little over 93,000 documents per GB.

 

This is all back of the napkin stuff, so don't treat it as writ.

1 0

Replies

replied on March 7, 2014

Perhaps this paper will be useful: https://support.laserfiche.com/GetFileRepositoryEntry.aspx?id=1847&mode=download. Keep in mind that the specifics of the documents will impact the database size as well, beyond the general approximations here. Having a large number of annotations will increase the ratio of database size to number of pages, for example.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.