Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can you "tell" MySQL server to cache a query?

Answer Posted / priti

Yes you can tell Mysql to cache the query and not to cache
the query with following options

SQL_CACHE
SQL_NO_CACHE

SELECT SQL_CACHE id, name FROM your_table_name; //This will
get cached

SELECT SQL_NO_CACHE id, name FROM your_table_name; //This
will not get cached

(Related cache setting should also be effective for
SQL_CACHE).

Thanks

visit my profile and get helped on PHP and other issues on
http://pritisolanki.blogspot.com

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many escape sequences are recognized in double-quoted strings in php?

929


What are the two types of variables?

919


What is super keyword in php?

1006


How does php serialize work?

968


What is the difference between explode () and split () functions in php?

1062


What is serialization in php?

908


What is urlencode and urldecode in php?

1048


What is difference between echo and print in php?

875


Why json is used in php?

940


How to run a php script?

949


How long is csrf token?

869


Why do we use hooks?

855


What is the use of ajax in php?

934


What is a php namespace?

917


Explain me what is the difference between $_files['userfile']['name'] and $_files['userfile']['tmp_name']?

865