Question

4
Replies
205
Views
Close popover
Sumanta Manna (SumantaM)
Accenture

Accenture
IN
SumantaM Member since 2012 8 posts
Accenture
Posted: July 16, 2018
Last activity: March 15, 2019
Closed

Can pega case work table (similar like pc_work ) be partitioned?

Our application currently holding huge volume of case data into work table. Even though we are using archival and purging to keep only recent 6 months data but still 6 months volume is too high. client has asked if work table can be partitioned or not. We don't have any prior experience on doing such partitioning on work table and not sure how this will really work as not sure how to let database know that which partition to use when performing insert or update operation on case via standard obj-save method. Any help is very much appreciated.

Case Management Data Integration
Moderation Team has archived post