Hi everyone,

it would be great if I where to receive an answer to this question :-)
I am unsure whether the issue is so easy to answer that everyone thinks it is self explanatory
or that it is a rather challenging question which requires lots of in-depth Fire Bird knowledge ^^

Best Regards,
James

---In firebird-support@yahoogroups.com, <bieten2004@...> wrote :

Hallo Everyone!

Although I spend a lot of time reading about performance tuning and optimizing Firebird according to the guides that the Firebird Team has published over the years, I could not figure out how to stop Firebird from creating about 2.2 GB of fb_sort files in the C:\Windows\Temp directory.

As described in other discussions the files disappear when the database is not being used intensively but I would not like to see them created in the first place.

As far as I see it, it is disadvantageous, when temp-files are created on the slow hard disk instead of keeping them in the fast RAM. I suspect that this also applies to Firebird.

You guys will very probably require system information in order to help:
Windows 2008 R2 Server (Virtual Machine)
Running Firebird 2.5.8.27089 in SuperClassic Mode
65,53 GB Ram available
Database Size 58,96 GB
8 CPU Cores

What do I have to do in order to stop the creation of fb_sort files?
My concern is that Firebird performance is suffering because of this.
I could of course also be mistaken and fb_sort-Files do not have a (negative) influence on performance.
If this were true, then I would be relieved :-)

Thanks a lot for your competent advice in advance and best Regards,
James