Thank's it works! Now the .gdb size is 3 MB!

.: SyamSyah :.

----- Original Message -----
From: "Kotala Zdeněk" <Zdenek.Kotala@...>
Subject: RE: [ib-support] Compact gdb file's

> > -----Original Message-----
> > From: SyamSyah [mailto:syamsyah@...]
> > 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