| Subject | Re: [firebird-support] Database File Size | 
|---|---|
| Author | Helen Borrie | 
| Post date | 2004-08-18T01:38:44Z | 
Oh, and I should have added that sweeping never returns space to the 
filesystem, it only frees space on pages....the file size doesn't magically
go down after a sweep. So, if you have a database that has blown out over a
long period, the only way to reduce the size of the database file and tidy
up the distribution of rows across pages is to restore.
/heLen
            filesystem, it only frees space on pages....the file size doesn't magically
go down after a sweep. So, if you have a database that has blown out over a
long period, the only way to reduce the size of the database file and tidy
up the distribution of rows across pages is to restore.
/heLen