what are you using to do the select? what components?
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Don
Gollahon
Sent: Wednesday, 13 November 2002 8:21
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Database won't close.


The original question still remains. I'm not using the BDE. Sweep is 0
so
"shouldn't" be kicking in. No errors in the error log. No sort on the
data. Just a straight select *. The file is created. Validation returns
no errors. Why isn't the database closing? Any ideas?

My only thought is that the Sweep IS kicking in. I can't think of
anything
else that would cause this.



""Don Gollahon"" <gollahon@...> wrote in message
news:INEIJJJDAFIPCPLIALBIMEPJCDAA.gollahon@......

> 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

http://docs.yahoo.com/info/terms/

>
>
>

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]