Hello,
I have a database with many documents.
Each night, an agent via a simple action delete all documents > 90 days
The number of document displays in view are correct, but the number of document in database properties is very important.
… I think, it’s a problem of soft deletion and not hard deletion.
How to reduce the size of the database to only active documents ?
thanks in advance
Nicolas
Subject: Why my database is so big ?
These extra documents may be the deletion stubs.If your db isn’t replicated, you may consider lowering the cutoff date (space savers tab of the replication settings of the db). See documentation for how to fine tune this.
Subject: RE: Why my database is so big ?
As far as I know deletion stubs are not counted as documents.
I would bet your application uses reader fields and some documents are not visible because you (and the servers) are not in those reader fields.
So if the server or the signer of the agent which does the documents removal are not listed in the reader fields they cannot acces to those documents=> they are never removed and you DB is growing with time !
Renaud
Subject: RE: Why my database is so big ?
is this your mailbox or any application which is runing on lotus notes or domino? do you know about compact ? try to do it .for more call me on ajitnarayan123@gmail.com
Subject: RE: Why my database is so big ?
It’s a developped database with many new document each hours.
Subject: RE: Why my database is so big ?
Are you compacting the db on a regular basis? If not, the db won’t get much smaller when you delete the docs.
What is the db % used value right now? If it’s a small number,then that means you have lots of left over stubs from previous deletions. Do a manual compact and see that happens to both the db size and %used value.
Subject: RE: Why my database is so big ?
Yes I tried to used in replication settings : “remove documents not modified in the last 90 days”
My database have no replica
The result is that I lost a configuration document of my database, because it never changed sinced many months.
It’s not what I want…
I replace my agent by @harddelete, I will see in the future if something changed.
Thanks
Nicolas
Subject: RE: Why my database is so big ?
This was not what I meant.I proposed to shorten the purge interval (period of time the deletion stubs are kept) NOT to chek the checkbox to remove the documents older than the purge interval.
Once again, it’s worth while reading the documentation, look for “Limiting the content of a replica” in the Notes admin help.