A single Falcon
database file stores all record
data, indexes, database structure and other information. The
individual information is stored within a series of pages.
Pages describe the internal storage allocation block within the
Falcon
storage engine. Pages are used to store
data and index information. The page size and how the
Falcon
engine caches and allocates pages for
use when storing information affect the performance of the engine
depending on the records that are being stored, index complexity
Pages cached in memory are used to store indexes, blobs and the structural data for a given tablespace. Active records (those read or updated are stored within a separate record cache.
All transactions on the database are logged and stored within a
separate log file. The log file is automatically flushed and the
changes written to disk when there is a
COMMIT
command, when auto-commit is
enabled, or automatically every 30 seconds when transactions are
not being employed.