Re: [firebird-support] Re: Firebird speed degrades during the day
Em 7/2/2013 08:53, Carlos H. Cantu escreveu: Are you sure you ran gstat when things were already slow (as asked by Thomas)? Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br Besides that... We should not forget he is using FB 1.5, I can't remember if was 1.5 or 2.X that fixes the problem with garbage colletion on long chain of duplicate value on indices... see you !
Re: [firebird-support] Re: Firebird speed degrades during the day
Are you sure you ran gstat when things were already slow (as asked by Thomas)? Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br prc --- 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/ prc Hi Thomas here are the results prc Flags 0 prc Checksum 12345 prc Generation 25779 prc Page Size 4096 prc ODS 10.1 prc Oldest Transaction 19525 prc Oldest Active 19526 prc Oldest Snapshot 19526 prc Next Transaction 19531 prc Bumped transaction 1 prc Sequence No 0 prc Page Buffer 0 prc Next Header Page 0 prc Database dialect 3 prc Creation Date Jan 22 2013 prc Attributes Force Write prc Sweep Interval 2000 prc prc ++ prc Visit http://www.firebirdsql.org and click the Resources item prc on the main (top) menu. Try Knowledgebase and FAQ links ! prc Also search the knowledgebases at http://www.ibphoenix.com prc ++ prc Yahoo! Groups Links
[firebird-support] Re: Firebird speed degrades during the day
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær 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. Check database statistics. A database that runs slower and slower is often due to programs not taking proper care of transactions. Firebird stores versions of records, so if there is an old transaction (any transaction except those that are both read only and read committed), there could be several versions of the same record, leading to slower and slower performance. Fixing such a problem could involve anything from asking a person to log out at night, to rewriting an entire system that was created without thinking of transactions at all. Set Thanks Svein, I will re-check all the transactions but am careful to start and commit transactions. This isn't a general problem with the program, it seems to be isolated to this user. Something you said did strike a chord though. This user does tend to have users that use terminal server to access the system. If they are not logging out of TS could this be a potential cause?
[firebird-support] Re: Firebird speed degrades during the day
--- In firebird-support@yahoogroups.com, 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.
[firebird-support] Re: Firebird speed degrades during the day
--- In firebird-support@yahoogroups.com, Leyne, Sean wrote: Thanks Svein, I will re-check all the transactions but am careful to start and commit transactions. This isn't a general problem with the program, it seems to be isolated to this user. Something you said did strike a chord though. This user does tend to have users that use terminal server to access the system. If they are not logging out of TS could this be a potential cause? Depends on several things. If a user walks away from their PC with your application running, how likely is it that your application would have an open db transaction? Closing a TS sessions (ie. not logging out) is like walking away from the PC. Is the TS setup to logoff/kill idle sessions? If not, applications will continue to run without end. The next time to user connects to TS, they will pick up the previous session. Sean Thanks Sean, Obvious when you put it like that, it shouldn't cause any issues then.
[firebird-support] Re: Firebird speed degrades during the day
--- 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/ Thanks Thomas, I'll contact the user and then get back with the results
Re: [firebird-support] Re: Firebird speed degrades during the day
--- 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/ 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/