INC-224038 · Issue 723258
Performance improvement for serviceregistry table queries
Resolved in Pega Version 8.6.5
The expression filter ($1 - "SSR"."pytimeout") in the queries for service registry table caused full table scans which might result in performance issue and even risk of contention/locking. This has been resolved by replacing the pyTimeout column reference in filters to the default value = 9000ms so that performance for these queries can be improved.