On 23 Oct 2009, at 4:06pm, Doug wrote: > PRAGMA page_size=4096
This PRAGMA governs characteristics of a database you have not yet created: it's pages on disk, not pages in memory. The page_size is a characteristic of the database file on disk. It has no effect in a program which opens a database file which already exists. If you're trying to manipulate the page_size of a database you must use this PRAGMA before the database file is first created. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
