Re: [sqlite] Consistent reads

2013-10-14 Thread Simon Slavin
On 14 Oct 2013, at 5:32pm, Jared Albers wrote: > Do SELECT statements automatically start a transaction in order to > obtain the SHARED lock? In other words, is the SHARED lock started as > a result of the SELECT statement or as a result of the transaction? I > was reading the "SQL as Understood

Re: [sqlite] Consistent reads

2013-10-14 Thread Jared Albers
at SELECT statements don't use transactions in addition to a SELECT statement not modifying the database? > Date: Fri, 11 Oct 2013 15:15:55 +0700 > From: Dan Kennedy > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Consistent reads > Message-ID: <5257b3bb.8000...@gma

Re: [sqlite] Consistent reads

2013-10-11 Thread Dan Kennedy
On 10/11/2013 02:29 PM, Paul Harris wrote: Hi again, I am wondering if there is any performance benefit in *not* wrapping multiple SELECT calls in a BEGIN/END transaction? As I understand it, with wrapping: BEGIN -- does nothing (yet) SELECT1 -- creates a SHARE-ONLY lock on the DB SELECT2 -- no