Friday, December 19, 2008

MySQL SQL_CACHE

Keywords: MySQL, SQL_CACHE, MySQL SQL_CACHE, MySQL Query Caching, Query Cache

MySQL allows its users to cache the query results if required.

The same shall be passed on through the MySQL Select statement. There are two keywords, MySQL supports while caching. They are:

SQL_CACHE
SQL_NO_CACHE

These keywords shall be specified in the MySQL select statements as follows:

select SQL_CACHE * from table_name;
select SQL_NO_CACHE * from table_name;

SQL_CACHE

The result of the passed MySQL query will be cached and used in future even if SQL CACHE is not enabled in my.ini file

SQL_NO_CACHE

The result of the MySQL query will not cached even if SQL CACHE is enabled in my.ini file

Basically MySQL has given us SQL_CACHE to make the caching in run time (dynamic)

For more information on mysql cache, pls visit

Keywords: MySQL, SQL_CACHE, MySQL SQL_CACHE, MySQL Query Caching, Query Cache

Featured Blog Topics: