Hi,

make a backup and a restore, and the size is reduced.

When deleting records, firebird does not reduce the filesize of the
databasefile. If you insert records after the delete, firebird will use
the free space in the database file.

Chris

Am 20.03.2005 um 11:05 schrieb yuppski:

>
>
>
> 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
>
>
>
>
>
>
>