Re: [HACKERS] using the same connection?

2001-02-07 Thread Peter T Mount
Quoting Mathieu Dube <[EMAIL PROTECTED]>: > Hi y'all, > Is it a bad idea for an app to keep just a couple of connections to a > database, put semaphore/mutex on them and reuse them all through the > program? > Of course I would check if their PQstatus isnt at CONNECTION_BAD and > reco

Re: [HACKERS] using the same connection?

2001-02-06 Thread Mathieu Dube
Well actually this particular connection is just for selects... On Tue, 06 Feb 2001, you wrote: > On Tue, Feb 06, 2001 at 11:08:49AM -0500, Mathieu Dube wrote: > > Hi y'all, > > Is it a bad idea for an app to keep just a couple of connections to a > > database, put semaphore/mutex on them and

Re: [HACKERS] using the same connection?

2001-02-06 Thread Nathan Myers
On Tue, Feb 06, 2001 at 11:08:49AM -0500, Mathieu Dube wrote: > Hi y'all, > Is it a bad idea for an app to keep just a couple of connections to a > database, put semaphore/mutex on them and reuse them all through the program? > Of course I would check if their PQstatus isnt at CONNECTI

[HACKERS] using the same connection?

2001-02-06 Thread Mathieu Dube
Hi y'all, Is it a bad idea for an app to keep just a couple of connections to a database, put semaphore/mutex on them and reuse them all through the program? Of course I would check if their PQstatus isnt at CONNECTION_BAD and reconnect if they were... I need some opinions