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: #PRAGMA SYNCRONOUS 2 begin transaction ... some very important update... commit ... some code unrelated to DB... #PRAGMA SYNCRONOUS 0 begin transaction ... less important update... commit ... some code unrelated to DB... #PRAGMA SYNCRONOUS 2 begin transaction ... some very important update ... commit Thank you , bye
