Subject RE: [firebird-support] Recommended method to limit file size ?
Author Leyne, Sean

> One table is growing very fast and is more than 20G now, still
> performance is very good. Record to this table are only appended not
> deleted or changed. To make backup faster I am thinking of splitting
> database over several files as it grows.

The latest new feature for Firebird (v1.5+) is the NBACKUP utility.

The utility will allow for:

- Incremental backups, with multiple increment levels (hourly, daily...)

- Backups at I/O speeds (Full [live] backup of 100MB database in 10

Accordingly, I would not change your database schema but have a little
patience for the next Firebird release.