Hi,

Just to add to Alexandre's comments.

At July 28, 2004, 13:29, delphic_viper wrote:

> We have firebird 1.0.2.908 installed on a 2000 server. We have been
> having extreme slowness issues and daily "wait transaction deadlock"
> errors.

How often is the transaction committed? Are the transactions started
for a long time?

> Also, over a 48-72 hour peroid of time the .gdb file will
> double in size from ~80 MB to ~160 MB, and will shrink back to the
> normal size of ~80 MB after a backup and restore. PLEASE HELP!!!!!!!

This is normal. Firebird will use some space for the record versions
until it can garbage collect them. But, it will not reduce the size
of the file. It will mark that space as free space that can be reused.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)