At 10:19 AM 14/06/2006, you wrote:

>[ .. huge snip .. ]
>
>When you say "You may want to consider a separate disk for the tmp
>space".
>You are talking about /tmp dir or another tmp dir
>inside /opt/firebird ?
>
>Diego

PLEASE TRIM YOUR MESSAGES !!!

He is talking about defining one or more directories for Firebird to
use for its temporary sort files. You specify them in the
TempDirectories parameter of firebird.conf.

Create a /home/firebird directory in a partition that has plenty of
space available, i.e. about 2 or 3 times the size of the database
file. Make the OS user 'firebird' the owner of the directory. Then,
uncomment TempDirectories in firebird.conf and enter the path to that
directory, e.g.

TempDirectories = /home/firebird

You can assign multiple TempDirectories using a semi-colon separated list, e.g.

TempDirectories = /home/firebird;/var/firebird

The server will have to be shutdown and restarted to make these
changes take effect.

^heLen