Subject Re: [ib-support] Database Size(after sweep)
Author Ann W. Harrison
At 04:00 AM 2/23/2001 +0000, Orlando Jimenez wrote:

>In interbase 5.1, I remeber, that when I did a sweep, over my database, the
>database size was of the original size again, but with interbase 6.0 doesn't
>happen this way.

Sweep has never released space back to the operating system.

>what can I do for my database be of the initial size?
>(only the gbak is the option?)

Backup/restore is the only option. Why do you want to
reduce the size of the database? If you're going to
store more data, putting into pages that have already
been allocated is faster than getting space from the
file system.


We have answers.