Don Gollahon wrote:

> We have a FB database that is over 600 MB. We have a routine that uses a
> select statement to return all records and it scans these and creates a text
> file. In this case there are about 1.5 million records. When it is done
> everything is fine but we go to close the database (db.close) and it hangs
> there. FB is running at around 50% CPU. We have left it a whole weekend
> before and it is still hung up on Monday morning. What could cause this?
> It is a very simple process.
> Sweep interval is set at zero. This is being tested on a local PC.
> Window2K. FB 1.0. Delphi 5 pro. IBX 5.03 components.

Could this be the background sweep thread?
I've experienced 'hangs' when closing, but these were "only" about 10
minutes (I don't recall which table and number of records). Anyhow, a
_weekend_ seems excessive, to say the least.


Regaards,
Aage J.