Quoting Mathieu Dube <mathieu_dube@videotron.ca>:
> 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 on that practice...
In the Java world it's called ConnectionPooling and is standard practice,
especially with Servlets/JSP/EJB's.
Peter
--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/