I discovered that as of sqlite 3.12 they changed the default page size from 1024 to 4096 ref: https://www.sqlite.org/pgszchng2016.html. Unfortunately I did not find this until I made a customer release.
In other versions such as cordova-sqlite-storage, cordova-sqlite-ext, and cordova-sqlcipher-adapter I explicitly kept the old page size (1024).
I plan to make the next release of this version with the old page size of 1024 as well for the following reasons:
better consistency
more efficient for small, frequent changes
more efficient for apps that store very little data
I discovered that as of sqlite 3.12 they changed the default page size from 1024 to 4096 ref: https://www.sqlite.org/pgszchng2016.html. Unfortunately I did not find this until I made a customer release.
In other versions such as cordova-sqlite-storage, cordova-sqlite-ext, and cordova-sqlcipher-adapter I explicitly kept the old page size (1024).
I plan to make the next release of this version with the old page size of 1024 as well for the following reasons: