Re: Performance question: Commit or rollback?

On Sun, Dec 25, 2011 at 12:00 AM, vinny <vinny@xs4all.nl> wrote:
> So, your read-only mode is basically a flag that forces your code to
> always issue a rollback at the end, instead of a commit for read/write
> mode.
>
> I find that a bit scary. :-)

It's three things:

1) BEGIN TRANSACTION READ ONLY instead of BEGIN TRANSACTION
2) A high level flag that tells the PHP code that it ought not to change things
3) ROLLBACK instead of COMMIT

ChrisA