Subject Re: [firebird-support] Performance Problems
Author Alexandre Benson Smith
delphic_viper wrote:

>We have firebird 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!!!!!!!

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

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
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil