Consider: 1. Create a new database, set the pragma page_size=512
2. Create a new database on the connection with ATTACH DATABASE '/tmp/number_two.db' AS second; 3. Issue pragma second.page_size=4096 to try and set the page size on the attached DB to 4096. 4. Read back with pragma second.page_size and get the default page size of 1024. (We are still on 3.10.1) Is it expected that the 4096 did not "stick?" Is there some relationship between page sizes in a main and attached DB? Thanks -- Ward (In real life, we also set journal_mode=WAL on both databases AFTER issuing the page_size pragma, in case it makes any difference.) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
