> > > We have a FB database that is over 600 MB. We have a routine that

uses

> a
> > 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.
>
> We can see in bigger databases, that the background sweep or even a

manually

> launched sweep doesn't finish even after 5 days.

I would say that you have a whole lot too much garbage in your db.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."