Command Line Options for Performance

Several command line options can affect database server performance.

Most of the performance command line options control resources for operations on the IQ store, which can have a major impact on performance. Options that affect only the resources available for operations on the catalog store may have a minor impact on overall performance.

• Memory Options
  SAP Sybase IQ uses memory for a variety of purposes.
• Options That Affect Timing
  Several command line options control when certain database server events occur.
• Network Performance Options
  Use the -gb (database process priority on Windows), and -p (maximum packet size) options to help you tune network performance.