As your database grows, it is crucial to manage data loading properly. Means of ensuring that your loads can scale to meet your needs include:
Buffer manager partitioning to avoid lock contention. Buffer partitioning based on the number of CPUs is enabled by default, and can be adjusted by setting server or database options. See “Managing lock contention” for details.
Allowing sufficient memory for loads, without allocating more memory than is available on your system.
Reserving space for data structures used during release savepoint, commit, and checkpoint operations. See “MAIN_RESERVED_DBSPACE_MB option” and “TEMP_RESERVED_DBSPACE_MB option” in the Sybase IQ Reference Manual.
For a list of other features that help you manage load performance, see “Tuning bulk loading of data”.
