I have bulk data in a list of CDT lets just say
Cases :{ A[], B:[],C:[],D:[] }
Now i want to write each instance of A,B,C,D to DB together because each instance of A,B,C,D is correspond to a case (or you can say 1 request)
and if once instance is failed then retry only that instance and rest of the instance to be persisted in DB.
I have implemented using for loop in PM and call sub process asynchronous . And in sub process i will write each of A ,B,C,D .
I wanted to check if there is a better approach considering performance.
Discussion posts and replies are publicly visible
Hi there,Using MNI instead of looping is a better option. What you can do is clean data once an instance of your subprocess completes so that you don't have to store large data and occupy memory on environment. You can find it on the given link under "Other" section on the side bar.
Sorry My requirement is to create ‘n’ times of CDT and for each CDT i have to call sub process that will write to Db. I dont want to create CDT list first and dump to DB . Right after one CdT is created i wanted to write to Db . How can we achieve it through MNI . can you shed some light
Do you need the CDT or only the writing to DB?Else think of a stored procedure?
after calling sub process that will write CDT to db. i dont want to hold current CDT instance.