Old Large DB timing issues

HCL Domino Domino Forum
1

I support a DB that was developed 15 years ago. It’s up to 20GB and 70K documents. Three primary types of user forms: one parent/child pair and one other. The parent form has grown quite large over time. I have two issues…

When weekly admin cleanup/compaction/backup/whatever runs, it can make the DB unusable (either unavailable or so slow it’s unusable) for a few hours. Will it help if we request they update this to the current ODS? It’s ODS 43 now. Or will that have no effect on this?

The main thing users do is run an action in the parent docs that does validation and creates files that end up in its child doc. Lately that it almost never fails that it gets to the end of that process and then times out after having done pretty much everything, but then I immediately rerun it and the second time it works. Is there anything that would explain that pattern, which I see about 90% of the time?

Thanks!

2

Subject: Re. Old Large DB timing issues

Yes, update the ODS to 48 or higher (if you are on Domino 8+) and enable the settings “Compress database design” and “Compress document data”. Savings example:

http://www.ibmsystemsmag.com/ibmi/administrator/domino/Performance-Improvements-in-Domino-8/?page=2 http://www.ibmsystemsmag.com/ibmi/administrator/domino/Performance-Improvements-in-Domino-8/?page=2

You can also read about the procedure in the Domino Administrator help: “Using database design compression”. Need to run compact for both ODS change and to execute the design and data compression steps. So you’ll have to do it twice.

Those must be some massive forms, or the documents must have huge attachments. Are the forms being stored along with each document? (i.e. does the database have the “Allow use of stored forms in this database” enabled and the form design has the “store form in document” box checked? If so, is that actually required?

For comparison, I’ve got two 15 year old databases, one with 748,687 documents that is 9.778GB, and the other has 656,385 documents and is 8.696GB. Both are on Domino 9.0.1 with design and data compression enabled as well as LZ1 compression for attachments.

3

Subject: Thanks for the feedback

I’ll follow through on that. The two other primary types of docs have attachments. This one does not , but it has a gazillion fields, edits, etc.

4

Subject: This DB went from >20G on ODS 43 to <15G on ODS 51

We’ll see if this improves some things. Thanks very much again for your help!

5

Subject: BTW It looks like DB settings are okay

But on ODS 43 of course those two compression checkmarks don’t do anything. I’ll submit a request for the admins to bump it up to ODS 52 - I need to check but I’m pretty sure all are servers are 9.0.1 now. They updated all our mail DBs to 52 but only update application DBs upon request apparently. I’ll also have to ask them to run a copy-style compact assuming they have enabled it for new DBs to be ODS 52. Thanks again for the tips - the article you pointed to was informative!