>> > Sweep interval: 1
>>
>> Why do you set it to 1 ? Every transaction launched sweep
> thread again and again !
>>
>> Reset it to default value ASAP.
>>
>> Regards,
>> Vlad
>>
>
> How do I do that?
>
> I mean, my Firebird usage for 3 years up today has been
> basically: "install the default FB package, xcopy the applications,
> run them".

The problem is in your database, not in Firebird itself (while i started to think
about disable to set sweep inteval less than, say, 1000. Except of zero, of course)

> So, I have no idea on where to tweak these parameters :D

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