search cancel

Process execution is slow after upgrade

book

Article ID: 243345

calendar_today

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.

Cause

DE65126

 

Environment

Release : 15.9.2

Component : Clarity Studio

Resolution

Resolved in 16.0.3

Additional Information

The query ran faster after creating an index in “EXTERNAL_ID” column in “PPA_TRANSCONTROL” table.