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?