Subject Re: [firebird-support] Firebird speed degrades during the day
Author Mark Rotteveel
On Wed, 06 Feb 2013 16:04:45 -0000, "peter_65@..."
<peter_65@...> wrote:
> Hi, I have a customer with FB 1.56 sitting on SBS 2008 std and mostly xp
> clients. In certain areas of the program where activity is heaviest
(server
> side procedures are being run to calculate the data) it takes over 5
> minutes to complete the process. I have put their fdb on my system and
do
> not have the same issue. At first I thought this pointed to an issue on
> their network but then they told me that if they run a backup and
restore
> there is no issue with delays and it runs fine; however, over the period
of
> a day the speed degrades back to the 5 minutes plus for the function to
> complete. If they back up and restore all is initially well again - but
> again things degrade over the period of the day. If anyone can tell me
what
> is occurring and how to fix it I would be most grateful.

Windows SBS 2008 is 64 bit, so maybe you are being bitten by the
filesystem cache consuming all memory (also discussed in another thread
this week).

Mark