Subject RE: [ib-support] Compact gdb file's
Author Kotala Zdeněk
> -----Original Message-----
> From: SyamSyah [mailto:syamsyah@...]
> Sent: Friday, November 01, 2002 10:34 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Compact gdb file's
>
>
> Hi,
>
> My .gdb size is 75 MB (600.000 record) and i am delete about
> 450.000 record.

> Why .gdb file's still 75 MB ?

It isn't possible shrink DB in real time.
If DB server do this in normal operation, then performance of server
gone down very quickly.


> How to compact this database ?

Backup and restore db.


Zdenek