Thanks, Sean:

The sweep interval is the default 20,000. The user backs up regularly,
too. I just added a gstat/gfix interface in the app for people to reset
the sweep to 0 just in case.

Years ago, Helen mentioned that for desktop apps, the firebird.conf file
setting for Garbage Collection be set:

GCPolicy = background, if the garbage collection was slowing down the
app. It was and that setting helped a lot.

Chuck

> Chuck,
>
>> Below is an excerpt from a madExcept bug report. Does anyone have any
>> idea why the FBClient.dll is hanging?
>>
>> This is code that run many times in a session without problems. The FB DB is
>> 2.52, superserver, local HD installed. The app is desktop app created in Delphi
>> XE2. The DB is local to the user's HD.
>>
>> Thank you for any insight that might help me keep this from happening.
>>
>> This issue of the DB hanging on a fetch happens once in a while and very
>> infrequently considering the number of fetches that occur during a user
>> session with the application. Not all users experience this issue. This
>> particular user has this the most often (a few times a month maybe)
> Have you considered that Firebird is processing a database sweep?
>
> What is the "Sweep Interval" for the database? (What does gstat report for the database)
>
>
> Sean
>
>