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 <mil...@gmx.de> 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]



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-dig...@yahoogroups.com 
    firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/

Reply via email to