Multiplexes include a single coordinator and permit multiple writers and readers.
This speeds up loads by employing the local CPU, memory, and disk resources of multiple computers.
Parallel loads must be on different tables. You cannot perform loads on the same table at the same time.
Multiple writer configurations are expected to increase the performance of parallel table loads nearly linearly if the table loads are run on separate write servers. For a sizable load, the overhead involved in inter-node communication is negligible. For small read-write operations, such as single row inserts or updates, however, the inter-node communication is significant compared to the DML operation itself, so Sybase recommends that you avoid running heavy workloads of small read-write updates on writer nodes.
Small batches mean loads that take less than a minute. Due to constant overhead, small transactions take longer on the writer. For long running transactions, the fixed overhead cost is a smaller percentage.