On Wed, 1 Sep 2004, Matt Wilson wrote:
>On Wed, Sep 01, 2004 at 02:46:39PM +0100, Christian Smith wrote:
>>
>> Add a new "BEGIN [TRANSACTION] FOR READONLY" statement, which begins the
>> transaction with a read lock only and doesn't allow the transaction to
>> even try to promote to a write lock.
>
>Why do you need a transaction at all if you're not going to commit?
>
>In my code, readers never use BEGIN, only writers do.
A transaction gives you a snapshot in time of the database. You may need
to do more than one query, and require a consistent snapshot for the
duration of the multiple queries.
>
>Cheers,
>
>Matt
>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
