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

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

book

Article ID: 206164

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

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, 15.9.1

Component : CLARITY PROJECT MANAGEMENT

Resolution

This is caused by DE59337, fixed in 15.9.2

Part of the issue was already addressed as DE55011 fixed in 15.9 - see New UX - Create project performance is slow on merge in ODF_ITEM_POSITIONS - DE55011