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