At 01:12 AM 6/06/2004 +0000, you wrote:

> Does FB allow dividing a database into separate files for
>indexes and/or individual tables within a single DB?

No.

> For example, in certain architectures scaleability and
>performance can be improved if separate storage devices are
>used for indexes, transaction logs, system tables, and user tables.

Not in this architecture. The engine totally controls the locations of
everything. It stores everything in pages. A page becomes a particular
type by being assigned to store a certain type of object (index nodes,
data, BLOBs, transaction inventory, etc.). It has some pages where it
stores only inventory.

One storage device isn't preferred over another for storing a particular
kind of page. When space on pages gets released through obsolescence, it
becomes available for storing more pieces of the same type of stuff. In
the case of table data, the released space is used for new rows or row
versions of data from the same table.

/hb