--- In [email protected], "Woody" 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. > > > > Along with Svein's good advice, I would also consider looking at the actual > indexes for high volume tables. I sometimes run a routine that will disable > all indexes and then re-enable them to update their stats. I forgot to > re-enable them once and my main client started experiencing the same > symptoms of slow downs during the day. Make sure you have proper indexes > created, not excessive, but necessary ones. > > HTH > Woody (TMW) >
Thanks Woody, It is well indexed.
