VigneshAmarnathan Member since 2011 5 posts
HCL Technologies Ltd.
Posted: 2 years ago
Last activity: 1 year 2 months ago

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.


Data Integration
Moderation Team has archived post
Share this page LinkedIn