DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, January 12, 2016

Slow Performance adcfgclone.pl appsTier - txkWfClone.sh/txkWfClone.sql 

This performance issue is due to high row counts in workflow tables.

Review the number of rows in the following tables.

select count(*) from wf_resources where name = 'WF_WEB_AGENT' and language = 'US';

select count(*) from WF_ITEM_ATTRIBUTE_VALUES;

select count(*) from WF_ITEM_ATTRIBUTES;

select count(*) from wf_activity_attr_values;

select count(*) from wf_process_activities;

select count(*) from wf_activity_attributes;

select count(*) from wf_notification_attributes;

select count(*) from wf_message_attributes;

 
Run the "Purge Obsolete Workflow Runtime Data" CCM request to reduce the number of rows in the Workflow tables.



No comments: