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