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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
