Subject Re: [firebird-support] Does Firebird need "compact" process
Author Lester Caine
itcmanggadua wrote:

> I am new to Firebird. From what I read in this list it seems that
> Firebird quite superior database. However I have little question, does
> Firebird requiring - from time to time - to compact the
> database...such as what is needed in Cloudscape.

No - backup and restore will return currently unused disk space, but as
soon as Firebird needs a bit more it will take it again. There is no
such thing as 'Pack'.

> Another question is how do you handle the limitation on table size (I
> read somewhere that it is limited to max 4GB). How is Firebird
> performance as a function of database size .....

I think the current 'record' is 120Gb - it is just a matter of the
limitations of the operating system - not Firebird. Speed is a matter of
what you are doing and how you are doing it rather than the size of the
database. Small tables can be very slow if badly configured, while large
ones can be very fast. If you have a speed problem then just ask and
pointers will be given ;)

> Thanks for any enlightenment.

Firebird is different - it actually works :)

Lester Caine
L.S.Caine Electronic Services