Re: Design Pattern to keep a connection opened?
John R Pierce <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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