Hello,
Since you have enough RAM, you can increase TempCacheLimit in
firebird.conf, for example, set 20Gb.
Fb_sort_xxx files will be created only if sorting will require more than
TempCacheLimit.
Regards,
Alexey Kovyazin
IBSurgeon
On 07.08.2018 10:35, bieten2...@yahoo.de [firebird-support] wrote:
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