Subject Database design question
Author ian

I have a question on database design and the use of multiple files. In
both Oracle and MS SQLServer, I always create a minimum of three data
files: system stuff, data tables and indexes. If the system has more
than one hard disk, then the index and data files will be placed on
separate disks, for improved performance.

With Firebird it is not possible to specify in which file(s) a
particular table or index is placed, but is there any change in
performance, either better or worse, using multiple files?

Assuming that files are added sequentially and depending on database
usage, it is likely that most transactions would be in the last file, so
could this speed up sweeping?

In the case of file corruption, is Firebird clever enough to recognise
that only one file is a problem, or does the whole database need to be