Why the db size is so large

HCL Domino Domino Forum
1

There is a db in our user’s server.

DB size :1.1G

The size of all documents in this db:64M

Why db size is so larger than the size of all documents ?

I check the db properties . 92.7% db space was used.

There is no replication of this db.(I thought whether delete stub cause it)

2

Subject: why the db size is so large

What compact option did you use? You could try creating a new replica if you can’t remove the deletion stubs. There is a technote on removing stubs as sometimes they can be a pain.

3

Subject: why the db size is so large

Have to look at the following:

Deletion Stubs (Notespeek)

View Indices (admin client)

Additional documents you can’t necessarily see at a glance, such as profile documents, documents with readers fields you’re not in, orphaned documents.

HTH

Kirsty

4

Subject: RE: why the db size is so large

Thank you for your quick response.

Could you please tell me how to check the Deletion Stubs ?

5

Subject: RE: why the db size is so large

You can use “sh database [filename]”, it will give you the information in the third or fourth line.Or you download a tool called “notespeak” (as mentioned before) and open the database within this tool.

6

Subject: RE: why the db size is so large

Thank you for your response.

Ｉ ｄｏｗｎｌｏａｄｅｄ ｔｈｅ Ｎｏｔｅｓｐｅａｋ ａｎｄ ｇｏｔ ｔｈｅ ｄｅｌｅｔｉｏｎ ｓｔｕｂｓ(=０)．

Ｉ ｈａｖｅ ｆｏｕｎｄ ｔｈｅ ｒｅａｓｏｎ． Ｔｈｅ ｖｉｅｗ ｉｎｄｅｘ ｓｉｚｅ ｉｓ １Ｇ．

Ｉｔ ｓｅｅｍｓ ｔｈａｔ ｔｈｅ ｖｉｅｗ ｏｐｔｉｏｎｓ ｉｓ ｎｏｔ ｃｏｒｒｅｃｔ．