SQLite Forum

customize min and max payload

customize min and max payload

(1) By sqlite3_preupdate_count (XiongZaiBingGan) on 2021-02-05 03:26:50 [link] [source]

  • question:
    • the page header has min and max payload value for internal page and leaf page.can i modify the min and max payload ? if i can and how to modify the value ?
    • my app scenarios is if record count is huge, i want to modify the min payload smaller to include more navigational information in a B+TREE page.can this improve the performance in search and reduce the I/O when memory is not enough to contain the entire database records.

(2) By Richard Hipp (drh) on 2021-02-05 12:36:01 in reply to 1 [source]

The original b-tree design (circa 2004) was to allow the minimum and maximum payload values to be configurable. However, that was never implement. Furthermore, as years went by, I began to realize that was a bad idea.

So the minimum and maximum payload values in the database header are now fixed constants. If you change them, SQLite will report the database as corrupt.