Specify the Page Size

Page size and buffer cache size affect memory use and disk I/O throughput for the database.

Note: The page size cannot be changed and determines the upper size limit on some database objects and whether LOB features can be used.

Page Size

Sybase IQ performs I/O in units of page size. When you create a database, you specify a separate page size for the catalog store and the IQ store. The temporary store has the same page size as the IQ store.

Page size for the catalog store has no real impact on performance. The default value of 4096 bytes should be adequate. The IQ page size determines two other performance factors, the default I/O transfer block size, and the maximum data compression for your database.

Data Compression

Sybase IQ compresses all data. The amount of compression is determined on the IQ page size.

Saving Memory

If your machine does not have enough memory, increase the memory and decrease the buffer cache sizes. Decreasing the buffer caches too much, however, can make your data loads or queries inefficient or incomplete due to insufficient buffers.

Parent topic: Optimize Memory Use
Related concepts
Paging Increases Available Memory
Utilities to Monitor Swapping
Server Memory
Manage Buffer Caches
Determine the Sizes of the Buffer Caches
Set the Buffer Cache Sizes
Optimize for Large Numbers of Users
Platform-Specific Memory Options