Do you select all 1.5 million records in as one select ? or a set of
structured "for select" loops?
if you pull them in as one select, then I don't call it a simple process.
You are pulling the entire database off the disk into memory which means
it's going back on to the disk as disk buffer, pretty useless exercise...
You would be much better off running such a process in a series of loops
which dig into the data in the same structure as your foreign key structure.
I'm not surprised it takes a long time to close the database in that case. I
would expect the database to more than tripl in size under this procedure
since there would be so much garbage... maybe you are running out of
diskspace too :-)
Alan
-----Original Message-----
From: Don Gollahon [mailto:gollahon@...]
Sent: Tuesday, 12 November 2002 7:52
To: ib-support@yahoogroups.com
Subject: [ib-support] Database won't close.


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]


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]