Using version 2.8.15, I'm doing the equivalent (via the API) of this:
sqlite /tmp/db1
PRAGMA SYNCHRONOUS=OFF;
ATTACH '/tmp/db2' AS db2;
db2 has previously had the command "PRAGMA default_synchronous=FULL" applied
to it. Will the writes to db2 be synchronous or not?
If db2 does inherit the synchronous attribute of the pragma prior to the
attach, is there a way to have it not do so?
(Why do I care? I have a temporary database which I open and which I want to
be as fast as possible, but don't care about recovery of the database
following a crash. That's db1. I also have a persistent database, db2, that
I need the synchronous writes for. I'm issuing queries using terms from both
databases and inserting into both database, thus the ATTACH rather than just
opening two separate handles.)
Thanks,
Derrell
ps. Is the behavior the same in Version 3?
