Subject RE: [firebird-support] Why is FB hanging in 64bit Win7/Vista and not 32bit?
Author Leyne, Sean
> I've asked this question before, but did not get any responses that could
> help.
> I have been seeing regularly, but still extremely intermittently, considering
> the number of times my program makes calls to the database, that in
> Win7/Vista, 64bit, and not in 32 bit, Firebird can hang. What's going on here?
> Anything I can do about this? The example below is not uncommon, but it
> can happen with any query of the DB throughout the program.

I would suspect that a database sweep is being triggered due to the Sweep Interval setting and the overall database activity.

Use gstat to print out the database header statistics, from there we can see some of the key metrics.