Process Audit generate unused AD_PInstance_Para

Description

system generates each process into Process Audit (table> AD_PInstance). Parameters stored in Parameters Audit tab (table: AD_PInstance_Para).

issue: System generates empty parameters also. e.g. run storage detail user not set parameter ad_org_id still create record in AD_PInstance_Para. This cause sql performance overhead.

improvement: we simple add condition, when parameter is null (not set by user) then record will be not generated to table AD_PInstance_Para.

Environment

None

Activity

Show:
Norbert Bede
June 28, 2019, 10:58 AM

any stakeholder ? we should save performance by removing unnecessary inserts and database size, thene housekeeping operations.

Carlos Ruiz
May 9, 2020, 6:06 PM

Closing as Potential Idea.

The deletion can be easily solved configuring HouseKeeping.

Assignee

Unassigned

Reporter

Norbert Bede

Tested By

None

Priority

Major
Configure