Thanks, Michael. The issue you pointed out is similar to mine and the
resolution was to set FIREBIRD_TMP environment variable. But this approach
does not allow me to restrict the size of the temp directory.

Our customers complain that Firebird creates 6GB temporary sort file and we
need to address this asap. Can anyone suggest a solution?

Thanks,

Alec

On Fri, Jun 1, 2012 at 11:28 AM, Michael Ludwig <milu71@...> wrote:

> **
>
>
> Alec Swan schrieb am 01.06.2012 um 10:16 (-0600):
>
> > I verified that FIREBIRD_TMP environment variable can be used to
> > control where temporary files are written. But TempDirectories in
> > firebird.conf seems to have no effect with or without FIREBIRD_TMP env
> > var set. Is TempDirectories setting broken in FB 2.5? Does it have no
> > effect on embedded FB version?
>
> Doesn't sound exactly relevant for the issue you're facing, but maybe
> you can make sense of the discussion and so gain some insights:
>
> TempDirectories parameter in firebird.conf ignored by global temporary
> tables - http://tracker.firebirdsql.org/browse/CORE-1241 - 03/May/07
>
> Michael
>
>
>


[Non-text portions of this message have been removed]