Command-line Options for Performance

Several command line options can affect database server performance.

Most of the options described in this section 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. If you need to specify options that affect the catalog store only, see Reference: Statements and Options > Database Options.

Performance tuning suggestions are given throughout this guide.

• Memory Options
  Sybase IQ uses memory for a variety of purposes.
• Number of CPUs Switch
  The -iqnumbercpus switch on the Sybase IQ startup command specifies the number of CPUs available to IQ.
• Options That Affect Timing
  Several command line options control when certain database server events occur.
• Network Performance Options
  Several options help you tune network performance.