> --- In [email protected], 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
Or even more informative: gstat -r -i Feel free to send me the output privately. I will have a look. -- With regards, Thomas Steinmaurer http://www.upscene.com/
