In PHP it was easy; no bothering with connection pooling. I wrote my scripts like I was the only one on the Internet. But with Java and Servlets it seems to be pretty much different. 1) Do I have to worry about connection pooling at all when I implement SingleThreadModel interface??? 2) Is it very very recommended to use connection pooling when SingleThreadModel interface is not used???
i would advise against using the SingleThreadModel. it is mainly suited for small sites with not much traffic. aside from that , yes copnnection pooling is the way to go in my opinion cause it is the middle ground between resources usage and clients number.
Well why will one need to use a connection pool if u are using a singleThreadModel.As there would be seperate instances handling the request and each of those instance would by default associate itself with seperate connections.On the other way round if we do make a pool of connections and keep it to be readily picked up by the instances, once the instance dies it doesn't releases the connection but destroys all the resources used by it , so there seems to be no point in using a pool
posted 16 years ago
Is there any Connection Pool capability in mm-mysql driver, or in some other JDBC MySQL driver?