Olivier Vidal wrote: > In terms of pure performance, is that there is a difference between: > > - SELECT > - SELECT > (so two read transactions) > > AND > > - BEGIN > - SELECT > - SELECT > - END
The documentation talks about writing as the primary reason for locks, but read-only transactions need to take a read lock. Two (automatic) transactions imply two lock/unlock operations. (It is possible to open a database file in read-only mode without any locks, but this would blow up if there were any writer.) Regards, Clemens
