Re: [firebird-support] High write access on disk

2019-11-12 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

[firebird-support] High write access on disk

2019-11-12 Thread kragh.tho...@yahoo.com [firebird-support]
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