I thought I posted this yesterday, but it seems to have gotten lost. Trying again...
[EMAIL PROTECTED] writes: > 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?
