AFAIK, 4, 8, 16 KB sized I/O based on flash memory shows better performance. (1.x ~ 3.x)
As a result, Android uses 4KB page size. It's good to embedded devices using flash memory. 2016? 3? 5? (?) 11:22, Donald Shepherd <donald.shepherd at gmail.com>?? ??: > On Sat, 5 Mar 2016 at 09:19 Roger Binns <rogerb at rogerbinns.com> wrote: > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > On 04/03/16 07:48, Richard Hipp wrote: > > > The tip of trunk (3.12.0 alpha) changes the default page size for > > > new database file from 1024 to 4096 bytes. ... This seems like a > > > potentially disruptive change, so I want to give you, the user > > > community, plenty of time to consider the consequences and > > > potentially talk me out of it. > > > > Can I talk you into it instead :-) My standard boilerplate for new > > databases is to set the page size to 4,096 bytes, and to turn on WAL. > > > > Roger > > > > We've headed the same way. 4,096 significantly reduced the size of our > databases when we switched to it some time ago. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
