*** 64,70 **** 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 Typing: --- 64,72 ---- 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. ! ! Just a note that you must also perform this command before you start a transaction (despite the optimization hint that every command should be in a transaction). Typing:
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|