Sybase 12.4.2 manual Working space for inserting, deleting, and synchronizing, 447

CHAPTER 12 Managing System Resources

Figure 12-4: Avoid I/O contention

The figure above illustrates how you want to spread access across separate disks to avoid I/O contention.

To avoid disk bottlenecks, follow these suggestions:

•Keep random disk I/O away from sequential disk I/O.

•Isolate IQ database I/O from I/O for proxy tables in other databases, such as Adaptive Server Enterprise.

•Place the transaction log and message log on separate disks from the IQ Store, Catalog Store, and Temporary Store, and from any proxy databases such Adaptive Server Enterprise.

Working space for inserting, deleting, and synchronizing

When you insert or delete data, and when you synchronize join indexes, Adaptive Server IQ needs some working space in the IQ Store. This space is reclaimed for other purposes when the transaction that needs it commits.

447