Performance of Modern UX Timesheet Grid Layout Slow - PostgreSQL only
search cancel

Performance of Modern UX Timesheet Grid Layout Slow - PostgreSQL only

book

Article ID: 223110

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Performance of modern ux timesheet grid is slow when updated by columns is added in the grid view 

Steps to Reproduce: 

  1. Login to Clarity Modern UX Navigate to Timesheet Workspace
  2. On the timesheet grid, navigate to columns and add 'Updated By' columnFilter for timesheet data 

Expected Results: The dataset fetched on the grid should be fast. 

Actual Results: The dataset fetched takes longer time when updated by columns is added to the grid. 

Environment

Release : 15.9.2 15.9.3

Cause

DE62405 -    

  • The query executed in the grid view has the column PRMODBY as part of select query.  

Workaround:

  • Remove the updated by column from the timesheet grid 

OR

  • Remove the timesheet grid module using the blueprint functionality

   

Resolution

Fixed in Clarity 16.0.0 and 15.9.3.1