Subject | Database won't close. |
---|---|
Author | Don Gollahon |
Post date | 2002-11-11T20:51:52Z |
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.
Thanks.
Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"
[Non-text portions of this message have been removed]
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.
Thanks.
Don Gollahon
gollahon@...
"The Original GenSoft Prodigal"
[Non-text portions of this message have been removed]