Re: transactions

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: transactions
Дата
Msg-id 3D7F923C.9D1CED8C@Yahoo.com
обсуждение исходный текст
Ответ на transactions  (Timur Irmatov <itvthor@sdf.lonestar.org>)
Ответы XML and PostgreSQL  (Dan Ostrowski <dan@triad-dev.com>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: parsing fields
Следующее
От: Francisco J Reyes
Дата:
Сообщение: pg_dumpall between Linux and FreeBSD.