>> 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.
+1. I have really seen over-indexed databases, at worst over-indexed with bad indices (e.g. 100% of duplicates) over the last few years. -- With regards, Thomas Steinmaurer http://www.upscene.com/
