Subject | Re: [firebird-support] What is the optimum pageSize? |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2019-11-14T22:44:33Z |
14.11.2019 23:30, Clyde Eisenbeis cte677@... [firebird-support] wrote:
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.
pages depending on record's size.
--
WBR, SD.
> 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.