Other Ways to Improve Resource Use

There are several ways to adjust your system for maximum performance or better use of disk space.

• Managing Disk Space in Multiplex Databases
  Get users to commit their current transactions periodically, and allow the write server to drop old table versions to free disk blocks.
• Managing Multiplex Resources Using Logical Servers
  Logical servers enable 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.
• Load Balancing Among Query Servers
  Using the 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.
• Restricting Database Access
  Schedule updates when demand is low for better query performance.
• Disk Caching
  Keep large amounts of memory in active use to balance the demand for real memory against the need for data from disk.