| Subject | FireBird .FDB file size won't go down even after deleting a large number of rows |
|---|---|
| Author | Hari Kolasani |
| Post date | 2005-11-29T19:29:32Z |
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?
2. Is there anyway to tune the performance when the FDB file size is
large?
- HK
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?
2. Is there anyway to tune the performance when the FDB file size is
large?
- HK