Re: PREPARE and transactions

On Sat, Jun 26, 2004 at 09:12:33AM -0400, Merlin Moncure wrote:

> > BEGIN;
> >     ... do something ... ;
> >     SUBBEGIN;
> >         EXECUTE ...;
> >         -- if it fails:
> >         -- SUBABORT;
> >         -- PREPARE ...;
> >         -- SUBBEGIN;
> >         -- EXECUTE ...;
> >         -- can continue as if nothing happened
> >     SUBCOMMIT;
> > COMMIT;
> 
> This is not an option: this requires that every EXECUTE be wrapped with
> a subtransaction.  This is a performance killer because it (at minimum)
> triples my statement turnaround latency.

Ah, good point.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)