Re: using the same connection?

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/