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.
