Subject Re: [firebird-support] What is the optimum pageSize?
Author Dimitry Sibiryakov
14.11.2019 23:30, Clyde Eisenbeis cte677@... [firebird-support] wrote:
> What is the max page size for Firebird 3?

16 kilobytes.

> Also, could you clarify a page?

Quoting
https://docs.microsoft.com/en-us/sql/relational-databases/pages-and-extents-architecture-guide?view=sql-server-ver15

"The fundamental unit of data storage in SQL Server is the page. The disk space allocated
to a data file (.mdf or .ndf) in a database is logically divided into pages numbered
contiguously from 0 to n. Disk I/O operations are performed at the page level. That is,
SQL Server reads or writes whole data pages."

Firebird definition of database page is the same.

> Does each record consume a page, or are could there be multiple records on a page?

Multiple records can be on one data page or one record can be split to several database
pages depending on record's size.

--
WBR, SD.