Customers complained of slow performance
The SQl query surrounding the UpdateProcessLastModifiedDate, a query that is used frequently, was returning an unnecesarily excessive amount of data. Much more than was required. Mostly due to the use of SELECT * and an improper WHERE clause configuration. There was also an UPDATE which was updating all the columns even though only a single column needed to be updated.
In all cases, for this query to perform its required function, the only column that needed to be updated was ModifiedOn in the ReportProcess table. This is done every time a change is made to a process.
A revised build of Workflow - 7.5.3001.64 or later, contains this fix. See KB Article HOWTO95421, for the correct build.
Servicedesk 7.5 Mp1