There is a DB that deletes and adds documents so frequently. As a result, It contains a lot of deletion stubs and its size keeps getting bigger. So sometimes it opens so slowly and even doesn’t open.
My question is there is best practice for maintaining this type of DB.
Thank you in advance.
Subject: Do you have to delete/add taht many documents?
Why are the documents being deleted and added so frequently? Can you perhaps redesign the application?
I am guessing that you delete all documents every night (or every hour?) and then create new documents, with mostly the same data. Could you perhaps keep the existing documents and just update them instead? That would be much better.
Describe teh application a little bit more. How many documents are being deleted/added, and how often?
Subject: Some suggestions
Karl-Henry is correct. If you can redesign the application to make updates instead of so many adds and deletes that would be preferable. The other option is to not retain your deletion stubs for very long by setting the purge interval to a small number of days. Also run compact regularly on the database to recover available space in the database and to keep its size small. Please be aware that when you keep your purge interval to a small number of days there is the higher risk of documents replicating back into the database.
Subject: how to shorten purge interval?
Thank you for your response. The reason why the DB must be updated so frequently is that I use LEI for data transfer and the LEI activity is a direct transfer activity with overwrite existing data option. This means it deletes existing documents and creates new documents every night. The documents transferred are over 90,000.
Once I set the LEI activity with Try update before insert option(which means it updates existing documents by comparing some keys) but I got a terrible result.(the activity took more than 10 hours to finish) So I changed the configuration. This is the back-ground story.
So as you suggested, I want to shorten the purge interval but I don’t know how. So could you explain a little bit more about it?
Subject: How to shorten database purge interval
Here you can find more info about how to set the purge interval in Notes databases: redirecting...