On Thu, 14 Jan 2016 16:54:04 +0100 Olivier Mascia <om at integral.be> wrote:
> Let a transaction (started with BEGIN TRANSACTION) which did only > reads. Is it any better to end it by COMMIT TRANSACTION or ROLLBACK > TRANSACTION, or is it completely insignificant? Why not do the right thing and remove the begin & commit transaction statements? An explicit transaction implies a unit of work, two or more changes to the database that must cohere for the database be consistent. Read-only operations (by which I suppose you mean SELECT) don't modify the database and don't belong in a transaction. --jkl