DE59337 New UX - Create project performance is slow on merge in ODF_ITEM_POSITIONS

book

Article ID: 206164

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

Slowness in performance on Project Create from New UX only, Classic works well.

Steps to Reproduce:

  1. Connect to a large dataset with at least 35k of projects and 50 picklists on every project (and select count(*) from odf_item_positions should be about 1.7M)
  2. Go to Classic UI and create a project. Note the time is under 5-10 sec
  3. Now connect to New UX
  4. Go to either Board or Grid view and enter the fields to create a new project

Expected Results: The project to be created in a similar amount of time as in Classic

Actual Results: The project create action takes 20-25 sec.

In SQL trace we noticed the slowness is caused by the MERGE in ODF_ITEM_POSITIONS. This is caused by the amount of records in this table.

Environment

Release : 15.9

Component : CA PPM PROJECT MANAGEMENT

Resolution

This is caused by DE59337, in review by Engineering

Part of the issue was already addressed as DE55011 fixed in 15.9 - see https://knowledge.broadcom.com/external/article?articleId=190674