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