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 [email protected], 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
