SumantaM Member since 2012 8 posts
Posted: 2 years ago
Last activity: 1 year 6 months ago

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
Share this page LinkedIn