Multiplexes now include a single coordinator and permit multiple writers as well as multiple readers. This architecture:
Supports read-write transactions from coordinator and write servers in the multiplex.
Allows multiple servers to perform loads to different tables at the same time. 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 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 writer servers. For a sizable load, the overhead involved in inter-node communication is negligible. However for small read-write operations, such as single row inserts or updates, the inter-node communication overhead 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.
