On 8/1/19, David Raymond <[email protected]> wrote: > [autovacuum] doesn't let you skip ahead in the overflow page chain.
Actually it does. Sort of. Sometimes. There is an optimization that lets the btree layer "guess" the next page in an overflow chain and verify its guess using the pointer-map information. If it guesses correctly, it can avoid reading a page from disk. But it has to fallback to reading the page if it guesses incorrectly. See the 22 lines of code here: https://sqlite.org/src/artifact/58d002f71?ln=4626-4648 -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
