The default page size for an SQLite database is 1024 bytes. The pagesize pragma can be used to change this value to any number between 512 and 65536.
However, I just discovered a bug such that if you chose a page size that is not a power of two, the database will be corrupted if its size ever grows above 1GB.
The simplest fix for this problem is to restrict database page sizes to be a power of two.
Is there anybody using a non-power-of-2 database page size? If I modify SQLite so that you cannot select a page size that is not a power of two, will it break anybody's code? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
