Out of all the available settings for the location of the workspace, which one of the following is the most optimal setting for performance when processing small transactions such as MQ messages?

Workspace = File writes workspace data to disk, introducing file I/O latency that degrades performance for high-frequency small transactions.

Workspace = Burst is designed for handling large-volume data in chunks and does not provide the in-memory efficiency needed for small, frequent transactions.

Workspace = Memory stores all workspace data entirely in RAM, avoiding any disk read/write operations during map execution. For small transactions such as MQ messages that arrive at high frequency, this eliminates I/O latency and maximizes throughput. No serialization to or from disk occurs, making it the fastest available workspace option for this workload type.

Workspace = Page uses a paging mechanism that incurs overhead from managing page boundaries, making it slower than a pure in-memory workspace for small transactions.