>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.

Check database statistics. A database that runs slower and slower is often due to programs not taking proper care of transactions. Firebird stores versions of records, so if there is an old transaction (any transaction except those that are both read only and read committed), there could be several versions of the same record, leading to slower and slower performance.

Fixing such a problem could involve anything from asking a person to log out at night, to rewriting an entire system that was created without thinking of transactions at all.

Set