Controlling performance and memory from the command line

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 the Sybase IQ Reference Manual for more information.

Performance tuning suggestions are given throughout this guide. See Sybase IQ Performance and Tuning Guide for a full discussion of how Sybase IQ uses memory, disk, and processors, the effect of user connections on resource use, and options you can set to control resource use.