| Subject | Re: [firebird-support] Re: Firebird speed degrades during the day |
|---|---|
| Author | Carlos H. Cantu |
| Post date | 2013-02-07T10:53:26Z |
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:
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
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:
>>prc> Hi Thomas here are the results
>> > 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> 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