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