Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Gergo Tolnai (Gerg?T70)
Saltech Consulting

Saltech Consulting
HU
Gerg?T70 Member since 2016 22 posts
Saltech Consulting
Posted: Oct 5, 2017
Last activity: Oct 6, 2017
Posted: 5 Oct 2017 4:18 EDT
Last activity: 6 Oct 2017 7:08 EDT
Closed

Batch update of a property in a column

Hello,

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?

Thanks!

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 6 Oct 2017 7:08 EDT
Laurence Brannigan (LaurenceB_GCS)
PEGA
Senior Software Solutions Engineer
PEG
GB

I'm not aware of a way to update the BLOB directly from SQL.

I realize this isn't a positive response, but I thought it best to give that update in case you were intending to perform this update over the weekend.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice