Re: Design Pattern to keep a connection opened?

On 11/05/11 8:46 PM, Bruce Johnson wrote:
> Why not just open a database connection, run the procedure and close it again? :
>
> Loop
> 	open db
> 	run proc
> 	close db
> End loop
>
> ?
> If the connection is staying open long enough to get stale and be disconnected, then you shouldn't be running into timing issues.
>
>

or do exactly that, only with a connection pooler like pgbouncer...



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

• Design Pattern to keep a connection opened? by Brandon Phelps
• Re: Design Pattern to keep a connection opened? by Bruce Johnson
• Re: Design Pattern to keep a connection opened? by Brandon Phelps
• Re: Design Pattern to keep a connection opened? by John R Pierce
• Re: Design Pattern to keep a connection opened? by John R Pierce
• Re: Design Pattern to keep a connection opened? by John R Pierce
• Re: Design Pattern to keep a connection opened? by John R Pierce