Subject | How to reduce database size after deleting records?(not by backup/restore) |
---|---|
Author | fukura8888 |
Post date | 2005-02-26T13:15:18Z |
Hi,
Although I've been deleting quite huge amount of records
in a firebird database, the size of the database file is
the same as before.
This was quite strange to me and looked up the firebird
manuals but they just recommended only backup/restore.
Problem is that I gotta periodically delete certain
amount of records to maintain the appropriate usable disk space.
I added that code in my .net application but the size of
the database keep growing although deleted records and
inserted records are exactly the same.
Is there any SQL command to clean up the garbage space/data
rather than backup/restore method?
Although I've been deleting quite huge amount of records
in a firebird database, the size of the database file is
the same as before.
This was quite strange to me and looked up the firebird
manuals but they just recommended only backup/restore.
Problem is that I gotta periodically delete certain
amount of records to maintain the appropriate usable disk space.
I added that code in my .net application but the size of
the database keep growing although deleted records and
inserted records are exactly the same.
Is there any SQL command to clean up the garbage space/data
rather than backup/restore method?