A method for optimizing the query cache of CI frame database _php Example

This paper illustrates the method of optimizing the query cache of CI framework database. Share to everyone for your reference, specific as follows:

A better query optimization in the CI framework is the database cache optimization

1. Turn on caching

Open $db in application/config.php
[' Default '] [' cache_on '] = TRUE;
Open $db in application/config.php
[' Default '] [' cachedir '] = './cache ';
and add a writable cache directory to the corresponding directory.

2. Open the cached statement in the corresponding query

Turn on the cache switch
$this->db->cache_on ();
$query = $this->db->query ("SELECT * from MyTable");
So that the following query is not cached
$this->db->cache_off ();
$query = $this->db->query ("SELECT * FROM members WHERE member_id = ' $current _user '");
Turn caching back on
$this->db->cache_on ();
$query = $this->db->query ("SELECT * from another_table");

3. Add the appropriate empty cache

The cache is not automatically deleted and can only be manually deleted
so you can clear the cache in the corresponding incremental deletion statement OK
//Clear All cache
$this->db->cache_delete_all ()/
*
empty A single cached
example.com/index.php/blog/comments page, the caching system puts all the generated cache files into
a folder named Blog+comments. If you want to remove the cached file corresponding to the example mentioned earlier, you
need to execute the following code:
* *
$this->db->cache_delete ('/blog ', ' comments ');

More interested in CodeIgniter related content readers can view the site topics: "CodeIgniter Introductory Course", "CI (CodeIgniter) Framework Advanced Course", "PHP Excellent Development Framework Summary", "thinkphp Introductory Course", " Thinkphp Common Methods Summary, "Zend Framework Introduction Course", "PHP object-oriented Programming Introduction Course", "Php+mysql Database operation Introduction Tutorial" and "PHP common database Operation Skills Summary"

I hope this article will help you with the PHP program design based on CodeIgniter framework.