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

Hi Thomas here are the results

Flags 0
Checksum 12345
Generation 25779
Page Size 4096
ODS 10.1
Oldest Transaction 19525
Oldest Active 19526
Oldest Snapshot 19526
Next Transaction 19531
Bumped transaction 1
Sequence No 0
Page Buffer 0
Next Header Page 0
Database dialect 3
Creation Date Jan 22 2013
Attributes Force Write

Sweep Interval 2000