Multiplex Performance

Adjust your system for maximum performance or better use of disk space.

Each server in the multiplex can be on its own host or share a host with other servers. Two or more servers on the same system consume no more CPU time than a single combined server handling the same workload, but separate servers might need more physical memory than a single combined server, because the memory used by each server is not shared by any other server.

• Managing Multiplex Disk Space
  Get users to commit their current transactions periodically, and allow the write server to drop old table versions to free disk blocks. Specifying the auto_commit option helps minimize space due to minimize version buildup.
• Managing Logical Server Resources
  Logical servers let you to manage the use of multiplex resources most effectively. Use logical servers to assign different sets of multiplex servers to different applications to meet their individual performance requirements.
• Balancing Query Loads
  Using the SAP Sybase IQ network client to balance the query load among multiplex query servers requires an intermediate system that is able to dispatch the client connection to a machine in a pool.