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

Php says that an array is an ordered map. But how the values are ordered in an array?

1045


What is binary safe string?

971


What is php and sql used for?

992


Write a query to find the 2nd highest salary of an employee from the employee table?

1032


What is the use of pear in php?

1000


What is the difference between fopen() and fclose()?

1101


How is php different from other languages?

872


What are the functions used in php?

1048


Tell me what's the difference between include and require?

993


How do you call a constructor for a parent class?

898


What is strstr php?

969


Is php a case sensitive language?

1144


What is default session time in php?

964


What is symfony php?

948


What is the difference between get and post in php?

1024