--- In firebird-support@yahoogroups.com, Thomas Steinmaurer 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.
>
> Run gstat -h for the database while things are slow and report back.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>

Thanks Thomas, I'll contact the user and then get back with the results