Hello Thomas,
Seems like your system generates a lot of sort files - the problem can
be that TempCacheLimit in Firebird 2.5 cannot be more than 2Gb -1.
When you set it to something between 2 and 4Gb, it means 0.
So, set something like
TempCacheLimit=21
Consider to tune other
Hey
Where I work we run a website with at growing number of users, over a period
of two months we have seen Firebird slow down at peek hours, where the number
of concurrent website users is about 6.000. Usually there is about 250
attachments, however when the slowdown occurs the number rises