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.
CollabPartnerz
IN
Hi SumantaM,
Instead of doing partition ,we can have one standard Agent which run,s for every 3 months and move all the data in work table to our custom table.
Lloyds Banking Group
GB
Hi SumanthaM,
Did you managed to partition your work table if so what was the approach you used to do that, we do have a similar requirement.
Thanks
Pegasystems Inc.
IN
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.