Provide additional storage resources to improve file disk I/O.
Performance related to randomly accessed files can be improved by increasing the number of disk drives devoted to those files, and therefore, the number of operations per second performed against those files. Random files include those for the IQ store, the temporary store, the catalog store, programs (including the Sybase IQ executables, user and stored procedures, and applications), and operating system files.
Conversely, performance related to sequentially accessed files can be improved by locating these files on dedicated disk drives, thereby eliminating contention from other processes. Sequential files include the transaction log and message log files.
Keep random disk I/O away from sequential disk I/O. Also for best performance, use only one partition from a physical device (disk or HW RAID set) per dbspace.
Isolate Sybase IQ database I/O from I/O in other databases, such as Adaptive Server® Enterprise, or any other I/O intensive application.
Place the database file, temporary dbspace, and transaction log file on the same physical machine as the database server.
Place the transaction log on a separate device or partition from the database to avoid database file fragmentation when using the -m option to truncate the transaction log.