SQLite Forum

Switching pragma synchronous to upgrade durability
Login
Excellent. Thanks for the help.

And just to clarify, any transaction will work, even if it is "empty"? For example, is it good enough just to do:
```sql
pragma synchronous=FULL;
BEGIN TRANSACTION;
COMMIT;
```

Or would I need to do something that forces the transaction to acquire a write lock or something like that?

Thanks,

David