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***