What if the autovacuum feature could be set based on a percent (pragma autovacuum_percent?) of the unused file size (if known) ? It could be useful to specify the "fullness" of data/keys of pages (pragma table_full_percent?), this way an "almost-readonly" table could use the full 100% of the page. So the path to the leaves would be shorter.
Fw: [sqlite] Version 3.1.0 API suggestion: autovacuum
=?iso-8859-1?Q?Miguel_Angel_Latorre_D=EDaz?= Fri, 21 Jan 2005 14:18:04 -0800