Making Drives Specialized
Go Up to Distributing I/O
A database server makes heavy use of both the virtual memory page file and of temporary disk space of the operating system. If possible, equip the server with multiple disks and configure the virtual memory file, temporary directory, and database files on separate physical disk devices. This can use parallel I/O to the fullest advantage.
For example, on Windows, you could locate the operating system files and pagefile.sys
on
C:
, the temporary directory and infrequently-used files on D:
, and database files on drives E:
and higher.
Change the location of the virtual memory file with Control Panel|System|Performance|Virtual Memory.
Change the location of the InterBase temporary directory by either specifying a system environment variable INTERBASE_TMP
, or editing the ibconfig
file and specifying the path of the appropriate directory as a value for the TMP_DIRECTORY
entry.