Single and Multi-File Databases - Firebird

Any Firebird database can be multi-file. You do not have to decide between single and multiple at the beginning. A single file database can be converted to multi-file at any time, using ALTER DATABASE (discussed in this chapter) or the gbak tool.

Specifying File Size for a Single-File Database

You can optionally specify a file length, in pages, for the primary file, following the PAGE_SIZE attribute. For example, the following statement creates a database that is stored in one 10,000-page-long file:

If the database grows larger than the specified file length, Firebird extends the primary file beyond the LENGTH limit until the filesystem size limit for shared access file is reached or disk space runs out. To avoid this, you can store a database in more than one file, called secondary files. The files can be on separate disks.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

Firebird Topics