Change in Default Page Size in SQLite Version 3.12.0

The Default Page Size Change of SQLite 3.12.0

1.0 Introduction

An SQLite database file consists of one or more "pages". For a single database file, all pages are the same size, though for different database files, the page size can any power of two between 512 and 65536, inclusive.

Since the SQLite database file format was designed (in 2003) the default page size for new databases has been 1024 bytes. This was a reasonable choice in 2003. But on modern hardware, a 4096 byte page is a faster and better choice. So, beginning with SQLite version 3.12.0 (2016-03-29)) the default page size for new database files has been increased to 4096 bytes.

The upper bound on the database cache size has traditionally defaulted to 2000 pa