From: | "alex b(dot)" <mailinglists1(at)gmx(dot)de> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: caching query results |
Date: | 2003-05-23 14:47:39 |
Message-ID: | 3ECE348B.7040900@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello!
yes, I have already found out, that a transaction is over with each
CGI-connection and its disconnection...
now, I'd be interested in that connection pooling... any ideas, where
I'd have to start?
TIA
scott.marlowe wrote:
> On Wed, 21 May 2003, alex b. wrote:
>
>
>>hello dear people without shaved necks!
>>
>>as many of you have already told me cursors are the way to go - now I know!
>>
>>there it is, kindly provided my BILL G.:
>>
>> BEGIN;
>> DECLARE <cursorname> FOR <query>;
>> FETCH <number_of_rows> FROM <cursorname>;
>> MOVE {FORWARD|BACKWARD} <number_of_rows> IN <cursorname>;
>>
>>
>>THANK YOU ALL VERY VIEL (much in german)!!!
>>
>>I will now have to implement session ID's into my CGI's...
>>
>>oh by the way... lets say a transaction has begun and was never
>>commited.. what will happen to it?
>>
>>is there a automatic rollback after a certain time?
>>or would there be ton's of open transactions?
>
>
> Well, transactions can't stay open across a disconnect / reconnect, so
> you'll have to use some kind of connection pooling to ensure they stay
> open between invocations of your cgi scripts.
>
> What environment are you developing in? Java has pretty good connection
> pooling, and so does PERL. PHP, not so good, but you can work around it
> if you understand the underlying, uber simple persistant connection
> methodology.
>
> There may be some open source connection pooling packages that can hold
> the transactions open for your cgi scripts, but I've not played with
> actual CGI in a few years now, so I have no clue how well any thing like
> that would work.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2003-05-23 15:09:00 | Re: [ADMIN] Q: Structured index - which one runs faster? |
Previous Message | j.sachanbinski | 2003-05-23 14:34:58 | Iterating through individual fields of OLD/NEW records in plpgsql trigger |