At 10:11 AM 3/08/2011, Leyne, Sean wrote:

>> 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.

What Sean said, but also make sure that you are using the 32-bit client with your 32-bit application (just in case you thought you had to use the 64-bit client and installed that...)

Make sure you are compiling your app with a version of IBO that supports Firebird 2.5! It will be IBO 4.9.-something - ask on the IBO list which sub-release fits the bill.

Did you check the firebird.log for any clues?

./heLen