Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do the sample trigger programs update all document fields, even if only one field has changed?

0
Posted

Why do the sample trigger programs update all document fields, even if only one field has changed?

0

These programs could be modified to update only the changed fields, and they would still work most of the time. While this would cut down on the number of transactions generated, it would probably NOT speed up their processing significantly, because the Notes API programs appear to spend most of the processing time searching for, opening, and closing each document, and very little time updating the individual fields in the document. The main drawback to this approach, and the main reason we don’t recommend it, is that if the Notes database were to get out of synch with the AS/400 file for any reason, and a field is updated in an AS/400 record where the Notes document is missing, then a Notes document will be created that contains only the updated field, and the other fields will be blank.

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.