Ward WIllats wrote: > sqlite> attach database '/tmp/RareData.db' as rd; <---- ATTACH SECOND DB > sqlite> pragma page_size=512; <----- SET MAIN DB PAGE SIZE > ... > sqlite> pragma journal_mode=WAL;
This sets the journal mode of _both_ databases to WAL. This requires that both database files are actually created. > sqlite> pragma rd.page_size=4096; <----- SET ATTACHED DB PAGE SIZE TO > 4K And now it's too late. To execute a PRAGMA only on the main database, use: PRAGMA main.journal_mode=WAL; Regars, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users