Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Use > instead of > in documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
4607eaf52f87231c1a2ae408f586533e |
| User & Date: | drh 2016-05-09 23:12:17 |
Context
|
2016-05-16
| ||
| 15:41 | Clarify wording in cintro.html. check-in: b9557433b1 user: drh tags: trunk | |
|
2016-05-09
| ||
| 23:12 | Use > instead of > in documentation. check-in: 4607eaf52f user: drh tags: trunk | |
| 20:14 | Fix a typo in the change log. check-in: 5100e74a66 user: drh tags: trunk | |
Changes
Changes to pages/fileformat2.in.
785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 |
<ul>
<li>X is U-35 for table btree leaf pages or
((U-12)*64/255)-23 for index pages.
<li>M is always ((U-12)*32/255)-23.
<li>Let K be M+((P-M)%(U-4)).
<li>^If P<=X then all P bytes of payload are stored directly on the
btree page without overflow.
<li>^If P>X and K<=X then the first K bytes of P are stored on the
btree page and the remaining P-K bytes are stored on overflow pages.
<li>^If P>X and K>X then the first M bytes of P are stored on the
btree page and the remaining P-M bytes are stored on overflow pages.
</ul>
<p>The overflow thresholds are designed to give a minimum fanout of
4 for index b-trees and to make sure enough of the payload
is on the b-tree page that the record header can usually be accessed
without consulting an overflow page. In hindsight, the designers of
|
| | |
785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 |
<ul>
<li>X is U-35 for table btree leaf pages or
((U-12)*64/255)-23 for index pages.
<li>M is always ((U-12)*32/255)-23.
<li>Let K be M+((P-M)%(U-4)).
<li>^If P<=X then all P bytes of payload are stored directly on the
btree page without overflow.
<li>^If P>X and K<=X then the first K bytes of P are stored on the
btree page and the remaining P-K bytes are stored on overflow pages.
<li>^If P>X and K>X then the first M bytes of P are stored on the
btree page and the remaining P-M bytes are stored on overflow pages.
</ul>
<p>The overflow thresholds are designed to give a minimum fanout of
4 for index b-trees and to make sure enough of the payload
is on the b-tree page that the record header can usually be accessed
without consulting an overflow page. In hindsight, the designers of
|