Re: transactions

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 #