Question

2
Replies
726
Views
Close popover
Vignesh Amarnathan (VigneshAmarnathan)
HCL Technologies Ltd.
Pega Senior System Architect
HCL Technologies Ltd.
IN
VigneshAmarnathan Member since 2011 5 posts
HCL Technologies Ltd.
Posted: May 1, 2018
Last activity: July 11, 2019
Closed

Work object archival strategy

Hi Team,

We have more than 10 million work objects in our application and looking for an archival strategy to improve system performance. We have around 3 million work objects for a particular case type which are resolved and rarely being reopened. Our customer wants to archive those 3 million work objects into a new temporary table and provide an option to view them in search and reports. We are planning to create an archive table - PC_WORK_ARCHIVE, PC_DATA_WORKATTACH_ARCHIVE, PC_HISTORY_ARCHIVE,... and move those records. Whenever user tries to reopen a work object, run SQL scripts to move them back to main table. Could you please let us know if this approach is feasible, if not provide us the best possible solution.

Thanks,
Vignesh.

Data Integration
Moderation Team has archived post