Gerg?T70 Member since 2016 22 posts
Saltech Consulting
Posted: October 5, 2017
Last activity: October 6, 2017

Batch update of a property in a column


I would like to update a column's value in for a big amount of records (millions). This could also be done by a SQL script BUT the property is also save in the BLOB which PEGA treats as the source of truth while doing Obj-Open.

The other approach we have is to retrieve the records, loop over them and do the changes. This process will take approx 3 hours using 9 nodes (5 agents each). Opposed to the SQL which would run for around 5 minutes as per our approximations.

My questions are:

Is there a way to update the BLOB from a SQL command (i think this would be the most efficient)

Or can you suggest any more performant way to do this?


Data Integration
Moderation Team has archived post
Share this page LinkedIn