Re: transactions - Mailing list pgsql-general

From Jan Wieck
Subject Re: transactions
Date
Msg-id 3D7F923C.9D1CED8C@Yahoo.com
Whole thread Raw
In response to transactions  (Timur Irmatov <itvthor@sdf.lonestar.org>)
Responses XML and PostgreSQL  (Dan Ostrowski <dan@triad-dev.com>)
List pgsql-general
Timur Irmatov wrote:
>
> Hello!
>
> I develop a web-site with cgi-s written in perl, which access
> PostgreSQL database..
>
> In my scripts I have a sequence of selects.
>
> Is it faster to wrap them all in transaction ?

Not only is it faster, it gives you the advantage of MVCC too,
presenting you a snapshot of the database. So no concurrent
UPDATES done by someone else are visible to you.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me.                                  #
#==================================================
JanWieck@Yahoo.com #

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: parsing fields
Next
From: Francisco J Reyes
Date:
Subject: pg_dumpall between Linux and FreeBSD.