HELP! how to cache mysql queries?

Hello guys! can someone help how to fix my problem? i know my problem is about caching. But i dunno what to do 'coz i’m a newbie in PHP coding. How can i cache mysql queries? Thanks in advance. Godbless! :slight_smile:

what do u mean by cache ? what you want to do exactly ?

I want to reduce the traffic in my site. I have my online radio station. And my listeners are experiencing an error displaying "Access denied to this site.’ Its all about traffic. But, my listeners are not that many, i think 10 to 20 listeners a day because we’re just starting. by the way I’m just running my site on a Free Web Hosting Site. here’s my site: radyomofm.co.cc I’m planning to move to a paid server.

To start you should read the manual entry on caching queries: http://dev.mysql.com/doc/refman/5.1/en/query-cache.html

and perhaps read about how they operate: http://dev.mysql.com/doc/refman/5.1/en/query-cache-operation.html

They are used with prepared statements.

However, with that few users, I doubt that query caching will help you that much. free shared hosting is usually always terrible in terms of service quality. I suggest moving to a paid hosting service if you are serious about this site.

I’m using scripts that retrieves, displays and deletes records from database
I’m using this to show the image of currently dj onair and for the song requests.

Sponsor our Newsletter | Privacy Policy | Terms of Service