Re: Limiting connection to mysql using old mysql module (not mysqli)

Per Jessen wrote:

Stut wrote:

Stefano Esposito wrote:

i'm in need to limit the numbers of conection to the database, whithout loose of functionality. There is a general strategy to achieve this?

1) Caching 2) Caching 3) Caching And if all that fails... 4) Caching

And mysqls query cache does that pretty well. http://dev.mysql.com/doc/refman/5.0/en/query-cache.html

Indeed, but only if you're making a lot of repetitive queries to the database. However, since the OP wants to reduce the number of connections to the database, query caching may reduce the time each connection is held for it will not reduce the overall number of connections. The point I'm trying to make is that while the query cache can be a huge improvement to some websites it's not a substitute for query optimisation. -Stut -- http://stut.net/