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
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
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
3 matches
Mail list logo