Aydin Toprak (topra)
Sr. System Architect
Pegasystems Inc.
topra Member since 2016 19 posts
Posted: February 20, 2017
Last activity: March 7, 2017
Posted: 20 Feb 2017 1:11 EST
Last activity: 7 Mar 2017 3:30 EST

How to implement batch operation (insert to db) in Activity


We have a very simple requirements which has a great impact for the application performance.

In one of our activity, we commit some marketing information to a database. The sequence of the activity makes this operation commit by each record which is quite expensive in terms of resource usage and also takes so much time to complete.

What we would like to do is to change this activity to commit once for each call (which generally have more than record).

When I try to do this in a single activity, I use a simple look and move "commit" operation of the rule. This works in order to achieve single commit count but only the last item in the list (page list) gets committed to DB. This is an expected issue as the loop constantly overwrites the previous records.

What is the best way to implement such a basic requirement which can be done with a simple prepared statement in Java?

I am quite new in Pega world. Any ideas, explanations and also recommendations will be appreciated.

***Updated by moderator: Lochan to update Categories***

***07/03/2017: Updated by moderator: Lochan to close post to future replies as the requirement is no longer current***

Low-Code App Development Data Integration Java and Activities System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.