Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Hemanth Garlapati (HemanthG)
Paypal

Paypal
IN
HemanthG Member since 2014 2 posts
Paypal
Posted: May 20, 2016
Last activity: May 30, 2016
Posted: 20 May 2016 5:41 EDT
Last activity: 30 May 2016 5:40 EDT
Closed

Is it possible to disable writing to pc_history_work table

Currently we write ~ a million records per day into pc_history_work table but don't use this data for any purposes. Just not performance, this table also causes maintenance overload. For eg: currently this table currently of size 520GB and we don't use this data  at all.

1) Is there any way we can disable writing to pc_history_table?
2) Does truncating this table affect any reports referring to this table?
 
 
Appreciate any help in this regard.
To see attachments, please log in.
Data Integration

Posted: 8 years ago
Posted: 23 May 2016 19:53 EDT
Lee Pederson (pedel) Engagement Strategy Content Expert & Principal Instructor - LSA
Pegasystems Inc.
US

Truncating would affect reporting of course but if you do not use historical "Performance" reports then truncation is fine.

There is a filter to limit what types of records are written to history. Decision Tree I believe.

It is very rare that history is used programmatically for example to return to a previously visited assignment then bring up the flow action that had previously been submitted from that assignment. 

 

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice