Reported Mailfile Size Incorrect

I have a few users mailbox’s where the database properties say a different size than the total amount of documents indicate.

An example is: within the database properties the total size is 166Mb but when we do a total count of the size column when I have a SELECT @All view, the size is 95Mb. We are even using Single Copy Template so that negates the size of the template.

Anyone point me in the right direction?

Thanks.

Subject: Reported Mailfile Size Incorrect

View and folder indexes take up space, and space that had been taken up by documents that have been deleted will not be released until the database is compacted.

Subject: RE: Reported Mailfile Size Incorrect

right. If I’m not mistaken, a new user’s mailbox takes up about 12 - 14 MB with no messages in it.

Subject: RE: Reported Mailfile Size Incorrect

Thanks for the help.

As I am using a Single Copy Template the size of the template (upto 17Mb) is not used within the users mailfile.

I have an automatic compact task running every night and I manually compact the problem mailfiles (load compact mail<mailfile> -B)

I realise there is a lot more within a mailfile than just mail but is it really as much as I have described in my post?

Thanks.

Subject: RE: Reported Mailfile Size Incorrect

Yes, it’s not unusual for 50% or more of a database to be used for non-document objects. Lots of views/folders is generally what causes that.

Subject: RE: Reported Mailfile Size Incorrect

Plus the Unread Documents index(es), the ACL, all of the Design document, etc…

There’s a heck on a lot more than just data documents stored in a Notes database.