Hi,

We develop a WF that queries an Oracle view every 30 minutes, until a specific record changes (the status of the project).

This WF may be running for several months, it generates 2 problems:

1- The WF becomes very heavy with so many records it generates.

2- Sometimes, after several months of running, the delay activities last much longer than configured (days later), which makes the WF not continue.

Does anyone have any idea how to improve the performance of a workflow of this type?

So that a database can be monitored with WF.

Example:

Thanks.