Performance considerations

When you invoke a user-written program at a defined exit point, it is important to realize that a call is issued each time a clear, delete, insert, or update operation is applied to the target table. Therefore, when data replication activity is high, overall performance is affected by the kind of actions that are implemented through the code in the user-written programs.

As a result, your programs should be written with performance in mind. They should be optimized as much as possible. In certain situations, you may decide that invoking user-written programs at specific points is not feasible if overall performance is adversely affected.