Here are a couple of questions for the most expert SQLite users. Question 1 Is #PRAGMA SYNCRONOUS a global database setting or is it possible to open two handles on the same database and set two different values for #PRAGMA SYNCRONOUS on the two handles ?
Question 2 Is it possible to change the value of #PRAGMA SYNCRONOUS on the same handle during the execution of the program ? In other words can a do something like this: begin exclusive transaction #PRAGMA SYNCRONOUS 2 ... some very important update... commit ... some code unrelated to DB... begin exclusive transaction #PRAGMA SYNCRONOUS 0 ... less important update... commit ... some code unrelated to DB... begin exclusive transaction #PRAGMA SYNCRONOUS 2 ... some very important update ... commit Thank you , bye
