Re: Numerous prepared transactions?

On 2012-01-20, Lincoln Yeoh  wrote:
> Hi,
>
> Is it viable to have very many prepared transactions? As in tens of 
> thousands or even more?
>
> The idea is so that a web application can do _persistent_ 
> transactional stuff over multiple pages/accesses/sessions and have it 
> rolled back easily, or committed if desired. I'm thinking that it 
> might be better to do this instead of reinventing transactions at the 
> application layer.

why not uses "session" like everyone else does,
don't load the database down with managing website logic.

> Would it be better to have separate postgresql databases for this? 
> One for the persistent transactions stuff, and one for "normal" 
> stuff, which will manage the persistent transactions.

what isolation level do you need for your "persistant transactions"?

-- 
⚂⚃ 100% natural