Using Multiple Disks for Database Files

Go Up to Distributing I/O

Similarly to RAID, you can distribute files of a multifile InterBase database among multiple physical disk drives.

For example, if you have a server with four physical disks, C:, D:, E:, and F:, and a 10GB database, you can create your database to take advantage of parallel I/O with the following database creation statement:

CREATE DATABASE 'C:\data\bigdata1.ib' PAGE_SIZE 4096
FILE 'D:\data\bigdata2.ib' STARTING AT PAGE 1000000
FILE 'E:\data\bigdata3.ib' STARTING AT PAGE 2000000
FILE 'F:\data\bigdata4.ib' STARTING AT PAGE 3000000;