Hi,

> 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.

In general, no. There's no "compact" functionality. It might be
useful, however, to do a backup-restore cycle, which might
shrink your database as well

> 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 .....

Do you mean a table size limit or database size limit?

Databases are pretty much unlimited in size.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com