Performance with the Audit in MUX when running for 2 or 3 months range.

Products

• Clarity PPM SaaS

Issue/Introduction

When you are trying to pull Audit for a specific object and attribute for a date range of 2-3 months it is taking very long for results to come back.

Steps to Reproduce: 

1. On a Clarity SaaS environment, identify an object with a high volume of audit records for a specific attribute i.e., an attribute that changes very frequently (in this case, resource object, attribute "Open for Time Entry".
2. Navigate to Modern UX → Administration → Audit.
3. In the Audit tab filter, select object = Resource and Attribute ID = priopen and date range at least 2 or 3 months.
4. Observe it is taking very long time.

Expected Results: It should return results within a few seconds, similar to a 1-month range with the same filter.

Actual Results: it is taking very long time over 60 minutes.

Environment

Clarity 16.4.2

Cause

DE210861

Resolution

Under review by Engineering team.