Hi, I have a strange problem which is probably quite obvious to someone. If anyone could help it would be much appreciated.
We run a site connected to a Firebird database, its only about 700MB in size. We have started running into a regular slowdown of the site and have narrowed it down to the database. The site runs very slowly (7000ms to 8000ms response times) when usually it is in the 2000-3000 region. The odd thing I have discovered is that the site works at normal speed, IF I run a SELECT on a couple of the tables in FlameRobin and keep them open and the transcations uncommited. The differnce in the web app response time goes from 2000-3000ms to 7000ms-8000ms just a couple of seconds after commiting the transactions and closing flame robin. Opening them again and running the select will bring the app response time right down. In Process Monitor fbserver.exe uses only roughly 50,000k which seems quite low and the server still has over 62% ram free. The server specs are: 4x Intel(R) Xeon(R) CPU X5650 @ 2.67GHz physical memory : 4096 MB 7gb disk free Firebird 2.5.3 x64 super server Windows 2008 R2 iis 8.5 The application is a remobjects server connected to a ISAPI dll. We are running a (perhaps out of date) optimised flamerobin.conf file. Here are the non hashed lines: DefaultDbCachePages = 384 TempBlockSize = 2048576 TempCacheLimit = 77108864 LockMemSize = 7048576 LockHashSlots = 30011 CpuAffinityMask = 15 I have tried increasing the DefaultDbCachePages to 9999 and it did not make a difference Any help appreciated. Thankyou Regards Philip