In order to trim down the size of the database after deleting record, it is
necessary to do a backup (With Garbage Collection), followed by a restore of
the database. This is the only way to reduce the size of the database.
Simply deleting the records will not reduce the size of the database.

Mike

----- Original Message -----
From: "yuppski" <yuppski@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, March 20, 2005 4:05 AM
Subject: [firebird-support] Database File size


>
>
>
> Hi All
>
> Ive got a database thats about 270 mb in size.
>
> I deleted the majority of the data within the tables and commited
> the transaction
> but the size of the database remained the same size.
>
> Why would this be ?
>
> How can I delete the majority of the data within the database and
> reduce the database file size ?
>
> I have about 14 tables with 1 trigger and 1 generator per table and
> about 8 of the tables have approx 3 indexes per table.
>
> tia
> Andrew
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>