Subject Re: Upgrading from FB 2.0.3 to Firebird- fbserver.exe goes to 100% CPU
Author vahrokh
> Run from the firebird\bin folder
> gfix -house 20000 <your database>
> Then look at gstat -h output again to confirm sweep interval
have default value of 20000
> Or you may disable autosweep if set sweep interval to zero. But
you need to run it by
> hand in this case from time to time.
> Regards,
> Vlad

I applied the suggested fix and now both the app and the admin tools
work perfectly.

The mystery is how could everything work flawlessy till this morning
(before the upgrade) with this parameter set to 1 and even more how
it got set to 1 to begin with, considering we did not even know about
the gfix command at all.

Anyway the important is that it's fixed, now I'll also apply to the
other dozen apps databases that for some reason are all set to sweep
= 1.