Managing System Resources

Tuning your hardware and software configuration provides better performance and faster queries.

• Performance Considerations
  Performance is usually measured in response time and throughput. A good design and indexing strategy leads to the largest performance gains.
• Optimize Memory Use
  Understanding how Sybase® IQ allocates memory can help you get the best performance from your system.
• The Process Threading Model
  Sybase IQ uses operating system kernel threads for best performance.
• Balancing I/O
  Balancing I/O on your system. It explains how to use disk striping and how to locate files on separate disks to gain better performance. Controlling the size of the message log file is also discussed.
• Options for Tuning Resource Use
  Tune your resources to create faster queries
• Other Ways to Improve Resource Use
  There are several ways to adjust your system for maximum performance or better use of disk space.
• Indexing Tips
  Choose the correct column index type to make your queries run faster.
• Managing Database Size and Structure
  Database size depends largely on indexing and data quantity. Create indexes for faster queries. Drop unnecessary objects to free disk space and shorten load times.
• Use UNION ALL Views for Faster Loads
  UNION ALL views can improve load performance when it is too expensive to maintain secondary indexes for all rows in a table.
• Network Performance
  Minor changes in your environment can solve some network performance issues.