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. 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!!!!!!!
>
>
>

Delphic_Viper,

We need more information, but I could bet that you have a long running
transaction...

Send to us the database statistics when the database are double sized...
use gstat for this...

By the way, what component connection suite do you use ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br