Documentation Source Text

Check-in [4607eaf52f]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Use > instead of > in documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 4607eaf52f87231c1a2ae408f586533e444c4744
User & Date: drh 2016-05-09 23:12:17.034
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
Unified Diff Ignore Whitespace Patch
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&lt;=X then all P bytes of payload are stored directly on the 
    btree page without overflow.
<li>^If P>X and K&lt;=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&lt;=X then all P bytes of payload are stored directly on the 
    btree page without overflow.
<li>^If P&gt;X and K&lt;=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&gt;X and K&gt;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