Hi All, I need your advice on below approaches for handling a scenari

Now we might generally get a doubt re how we must ensure that Appian is able to handle the process and all the operations in it comfortably. This should be answered by Appian Health Check at forum.appian.com/.../Appian_Health_Check.html. Here are a few examples:
Example 1: Let's say you have opted for Approach 2 (without any tweaks) and have written 200 detail records with huge amount of data. This operation might fall under High/Medium risk and the category falls under 'Slow data store operations' at forum.appian.com/.../Appian_Health_Check.html.
Example 2: Let's say you have opted for Approach 2 (without any tweaks) and have processed 200 detail records(as you have earlier said that each detail record needs some processing prior to update) in a single shot. The operation might be flagged as High/Medium risk and the category falls under 'Slow expressions' at forum.appian.com/.../Appian_Health_Check.html.

If you aren't aware of the Health Check and its applications, still you can also make a solid design by studying the Health Check concepts and the practices suggested in it.

Further I am not sure if you have designed the processes (which deals with huge data-sets) under Health Check's constraints. But doing so for some time will give you a wider insight and experience over how to deal with the scenarios which you have asked for.

Now we might generally get a doubt re how we must ensure that Appian is able to handle the process and all the operations in it comfortably. This should be answered by Appian Health Check at forum.appian.com/.../Appian_Health_Check.html. Here are a few examples:
Example 1: Let's say you have opted for Approach 2 (without any tweaks) and have written 200 detail records with huge amount of data. This operation might fall under High/Medium risk and the category falls under 'Slow data store operations' at forum.appian.com/.../Appian_Health_Check.html.
Example 2: Let's say you have opted for Approach 2 (without any tweaks) and have processed 200 detail records(as you have earlier said that each detail record needs some processing prior to update) in a single shot. The operation might be flagged as High/Medium risk and the category falls under 'Slow expressions' at forum.appian.com/.../Appian_Health_Check.html.

If you aren't aware of the Health Check and its applications, still you can also make a solid design by studying the Health Check concepts and the practices suggested in it.

Further I am not sure if you have designed the processes (which deals with huge data-sets) under Health Check's constraints. But doing so for some time will give you a wider insight and experience over how to deal with the scenarios which you have asked for.