*** 62,72 ****
PRAGMA page_size=4096;
! Now create your tables *immediately* (if you close down the SQLite command line program and reopen the DB, the page size is reset to 1024). The page size must be set before the first table is created.
! Once that tables made, you can't change the size. It is fixed and does not need to be re-specified.
!
! Just a note that you must perform this command before you start a transaction (despite the optimization hint that every command should be in a transaction).
Typing:
--- 62,72 ----
PRAGMA page_size=4096;
! Now create your tables *immediately* (if you close down the SQLite command line program and reopen the DB, the page size is reset to 1024).
! You only need to do PRAGMA page_size=4096 once, before your first
! CREATE TABLE statement. Once the database exists, the page size
! is fixed and can never change.
Typing:
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|