| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | Timur Irmatov <itvthor(at)sdf(dot)lonestar(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: transactions |
| Date: | 2002-09-11 18:58:04 |
| Message-ID: | 3D7F923C.9D1CED8C@Yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | greg | 2002-09-11 19:29:06 | Re: psql: \pset pager 'always'? |
| Previous Message | Joe Conway | 2002-09-11 17:31:52 | Re: parsing fields |