#1 — Best: Script Task using a!forEach()

This is the most efficient and recommended approach.

1. Executes entirely within a single expression evaluation
2. No process instances are created
3. No engine round-trips per record
4. Minimal memory footprint and near-zero process engine load

a!forEach() operates on the full dataset in memory, making it ideal when the complete list of records is already available. It effectively behaves like a functional loop and returns the transformed list in one operation.

👉 Why it wins:

Maximum performance, lowest overhead, and aligns with Appian best practices for in-memory data transformation.

#2 — Good: Start Process Smart Service with MNI (Parallel Execution)

This approach starts one asynchronous process per record using Multiple Node Instances (MNI).

1. Runs in parallel, improving overall execution time
2. Load is distributed across multiple execution engines
3. Each record is handled independently in its own process

👉 Why it’s strong:

Unlike subprocess, this method leverages Appian’s execution engine load balancing, preventing bottlenecks when handling large datasets.

👉 Trade-off:

Higher memory usage due to multiple process instances.

#3 — Moderate: Subprocess Node with MNI (Parallel but Single Engine)

Also uses MNI to process records in parallel, but with a key limitation:

1. All subprocess instances run on the same execution engine as the parent
2. Can lead to engine saturation under heavy load
3. Execution speed may degrade as volume increases

👉 Why it ranks lower:

Lacks cross-engine distribution, making it less scalable than the Start Process approach.

#4 — Worst: Synchronous Subprocess in a Loop (Sequential Execution)

This is the least efficient pattern.

1. Executes one record at a time (sequential)
2. Parent process waits for each subprocess to complete
3. Holds memory and process context for the entire duration

👉 Why it performs poorly:

1. No parallelism
2. High memory usage
3. Increased execution time
4. Single-engine processing

Official Documentation

1. Looping in Appian: https://docs.appian.com/suite/help/latest/looping.html
2. Subprocess Activity: https://docs.appian.com/suite/help/latest/Sub-Process_Activity.html
3. Start Process Smart Service: https://docs.appian.com/suite/help/latest/Start_Process_Smart_Service.html
4. Ways to Start a Process: https://docs.appian.com/suite/help/latest/Ways_to_Start_a_Process_From_a_Process.html