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

Where to put php files in apache server?

1019


How check field is empty or not in php?

1099


What is the use of offset in mysql?

1003


Does php 7 support multiple inheritance?

1084


How to display your correct URL of the current web page?

1159


What is the difference between substr() and strstr()?

1445


How do functions work?

1177


Is php dying 2018?

1007


Are php short tags acceptable to use?

1007


Which is not a php magic constant?

1116


Explain scalar type declarations in php7?

1018


Which is useful for method overloading?

1186


Explain how can we increase the execution time of a php script?

1045


How many open modes available when a file open in PHP?

1216


Explain what is the function file_get_contents() usefull for?

1021