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.

Reply via email to