Subject Re: [ib-support] gds_sort file
Author Helen Borrie
At 09:31 AM 11-12-02 +0800, you wrote:
>Dear All,
> I set the following in the isc_config file: TEMP_DIRECTORY 20000
> "/usr/tmp".
> But the sort file still go the /tmp! I am using
> FirebirdCS- running on Red hat 7.2. Any setting I missed? Thanks!

1. You would have to restart the server to have the new parameter take effect.

2. 20 Kb is a very small sort space: practically useless. Presumably the
server will need to look for additional sort space for most operations. If
/tmp is available, I guess it is the only place it could go.