We have undergone some performance issues recently, opening an existing notes document in Read mode is taking more time.
We found that issue is with an Editable field in the document, which contains an @DbColumn lookup to generate the choices for Dialog List Keyword fields.
In order to resolve this issue we modify the lookup to execute only when the document is in Edit mode. To have the @DbLookup or @DbColumn execute only when the document is opened in Edit mode, we used @IsDocBeingEdited in combination with @DbLookup or @DbColumn formula.
For example: @If(@IsDocBeingEdited;@DbColumn("";"":"INVENTRY.NSF";"Inventory On Hand";2);"")
