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/