Subject Re: [firebird-support] FireBird .FDB file size won't go down even after deleting a large number of rows
Author Lester Caine
Hari Kolasani wrote:

> I have been using a FireBird database in my app and the database
> grew to several thousand rows and the .FDB file size went up to 600
> MB over a period of a few weeks.
> First of all I noticed that the application runs very slow (SQL
> queries) when the file size is big.
> So, I deleted all the rows in the database using an SQL DELETE
> statement via ODBC, the file size still remains at 600 MB even when
> when the database is empty.
> 1. Is there anyway to bring the .FDB file size down?
Only backup and restore will reduce the file size, once allocated the
disk space is maintained and reused as new records come allon.

> 2. Is there anyway to tune the performance when the FDB file size is
> large?
It sounds as if you need to look at your tarnsaction handling. There is
obviously something keeping a connection open that requires a number of
copies of each record that is modified to be retained. What are you
using ODBC with?

Lester Caine
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.