can we cache queries in mysql with php. or please suggest me some ways to do so.
A:
MySQL has it's own internal query cache. You could set up your own system using shared memory, memcached, simple text files, et al, but MySQL's pretty good at handling it without any extras.
tadamson
2010-05-12 06:30:06
can u provide me some links from where i can learn this!!
Praveen Prasad
2010-05-12 06:38:37
A:
Normally you leave it up to MySQL to cache what it seems necessary. MySQL does use a query cache that caches results of queries and this cached data is used if the same query is repeated. MySQL deals with nitty gritty details transparently.
Salman A
2010-05-12 06:35:19
The above poster has posted the necessary links. In general, you should add this to your bookmarks: http://dev.mysql.com/doc/refman/5.1/en/
Salman A
2010-05-12 07:29:15