| Subject | Re: how can the creation of fb_sort files be avoided? 2.2 GB of fb_sort files |
|---|---|
| Author | |
| Post date | 2018-08-07T07:35:45Z |
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