Vault database is huge

ww · Post by ww » Thu Aug 18, 2005 10:50 am

On disk, my VSS database was about 250 MB. I've loaded everything into Vault, and my Vault database is almost 2GB on disk (after shrinking). Is this typical/reasonable? The tblfileinfo table is 460MB, so I guess that's close, but there's a lot of space being taken up by metadata. tblfolderentries has 13,913,505 rows, for 895MB.

ian_sg · Post by **ian_sg** » Thu Aug 18, 2005 2:43 pm

tblfolderentries tends to be big. There are a number of reasons for this, but in general you need not be concerned that this is unusual.

ian_sg · Post by **ian_sg** » Thu Aug 18, 2005 2:55 pm

I can probably be slightly more helpful than that, actually. The most likely cause for such an enormous tblfolderentries after a VSS import is labels. Vault creates temporary folders to maintain the accuracy of historical VSS labels, which are immediately deleted, but the net result is lots of rows in tblfolderentries.

If you wanted to reduce the size of your database enough to trade off labels and endure another VSS import, you could delete the database and re-import without selecting labels.

ww · Post by ww » Thu Aug 18, 2005 3:00 pm

Too late to redo the import now, even if I wanted to. I realized after I did the import that I could have done without more of the labels than I thought. I suppose there's no way to delete labels?

ian_sg · Post by **ian_sg** » Thu Aug 18, 2005 3:03 pm

Unfortunately there is no way to delete them in a way that will free up the space.