How does one set the page_size ? according to the documentation "The page-size may only be set if the database has not yet been created. " So how do you execute the pragma prior to creating the DB? without calling sqlite3_open to get a DB handle that is needed to call prepare/step ? Ive also tried setting this via -DSQLITE_DEFAULT_PAGE_SIZE=4096 at compile time and still get the default pagesize of 1024. Thanks
- [sqlite] How to set pragma page_size Ken