Question
HCL Technologies Ltd.
IN
Last activity: 11 Jul 2019 5:57 EDT
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.
Pegasystems Inc.
AU
The ideal approach is to build an archive environment and import the Purged & Archived rap in to this environment. When ever, you want the archived case, then you can export it form Archived environment and import it in the production environment.