On 5 Mar 2016, at 7:10pm, Paul Sanderson <sandersonforensics at gmail.com> wrote:
> The savings as mentioned earlier are IO related due to matching the > page size to the underlying hardwares block size and for larger > payloads ensuring less IO due to no or lesss overflow pages. An important point. Because of the way I design my schema, most of my tables have short rows. I rarely have more than 8 columns in a table. Because SQLite fetches/writes a whole page for each access (?) having large pages does not generally benefit me. Simon.