i came across an article and this has cautioned me before implementing connection pooling...
so I would request your views on the topic and suggest me the best ways to do pooling or if you are against pooling, please explain your opinions...There are a couple of points that should be considered before using pooled connections. It is possible that if used incorrectly this can produce a security risk, or at least introduce problems. If your web server using PHP (for example) and pooled connections, does things to the connection, that leaves it it a different state at the end to how it started, you shouldn't use pooling. Lets take a example of this. Assume you have a page that requests a password from a user, then using this password, alters the default database to one that other users are not allowed access to, if this connection is reused by another user, they will have access to data they should not be allowed to see.