Process execution is slow after upgrade
Article ID: 243345
Updated On:
Products
Clarity PPM SaaS
Issue/Introduction
Your custom process is slow after an upgrade.
The process has gel script which has a SQL that took the majority of the time
The join with “PPA_TRANSCONTROL” table is causing the query to take a lot of time.
Environment
Release : 15.9.2
Component : Clarity Studio
Cause
DE65126
Resolution
Resolved in 16.0.3
Additional Information
The query ran faster after creating an index in “EXTERNAL_ID” column in “PPA_TRANSCONTROL” table.
Feedback
Yes
No
Powered by
