Gitiles
Code Review Sign In
www.giggi.me / code-igniter-v3-giggi / 10c3f41cbe5bd3bb66fd106cc9fb171ffcc7364b / . / user_guide / database / caching.html
blob: 05c6b3304da3cb50a7afcd1f8a0f55eec9e2a289 [file] [log] [blame]
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2<html>
3<head>
4
5<title>Code Igniter User Guide</title>
6
7<style type='text/css' media='all'>@import url('../userguide.css');</style>
8<link rel='stylesheet' type='text/css' media='all' href='../userguide.css' />
9
admin17a890d2006-09-27 20:42:42 +0000[diff] [blame]10<script type="text/javascript" src="../nav/nav.js"></script>
admin2296fc32006-09-27 21:07:02 +0000[diff] [blame]11<script type="text/javascript" src="../nav/prototype.lite.js"></script>
admin17a890d2006-09-27 20:42:42 +0000[diff] [blame]12<script type="text/javascript" src="../nav/moo.fx.js"></script>
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]13<script type="text/javascript">
14window.onload = function() {
15 myHeight = new fx.Height('nav', {duration: 400});
16 myHeight.hide();
17}
18</script>
19
20<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
21<meta http-equiv='expires' content='-1' />
22<meta http-equiv= 'pragma' content='no-cache' />
23<meta name='robots' content='all' />
24<meta name='author' content='Rick Ellis' />
25<meta name='description' content='Code Igniter User Guide' />
26
27</head>
28<body>
29
30<!-- START NAVIGATION -->
31<div id="nav"><div id="nav_inner"><script type="text/javascript">create_menu('../');</script></div></div>
32<div id="nav2"><a name="top"></a><a href="javascript:void(0);" onclick="myHeight.toggle();"><img src="../images/nav_toggle.jpg" width="153" height="44" border="0" title="Toggle Table of Contents" alt="Toggle Table of Contents" /></a></div>
33<div id="masthead">
34<table cellpadding="0" cellspacing="0" border="0" style="width:100%">
35<tr>
admin10c3f412006-10-08 07:21:12 +0000[diff] [blame^]36<td><h1>Code Igniter User Guide Version 1.5.0b1</h1></td>
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]37<td id="breadcrumb_right"><a href="../toc.html">Full Table of Contents</a></td>
38</tr>
39</table>
40</div>
41<!-- END NAVIGATION -->
42
43
44<!-- START BREADCRUMB -->
45<table cellpadding="0" cellspacing="0" border="0" style="width:100%">
46<tr>
47<td id="breadcrumb">
48<a href="http://www.codeigniter.com/">Code Igniter Home</a> &nbsp;&#8250;&nbsp;
49<a href="../index.html">User Guide Home</a> &nbsp;&#8250;&nbsp;
50<a href="index.html">Database Library</a> &nbsp;&#8250;&nbsp;
51Database Caching Class
52</td>
53<td id="searchbox"><form method="get" action="http://www.google.com/search"><input type="hidden" name="as_sitesearch" id="as_sitesearch" value="www.codeigniter.com/user_guide/" />Search User Guide&nbsp; <input type="text" class="input" style="width:200px;" name="q" id="q" size="31" maxlength="255" value="" />&nbsp;<input type="submit" class="submit" name="sa" value="Go" /></form></td>
54</tr>
55</table>
56<!-- END BREADCRUMB -->
57
58
59<br clear="all" />
60
61
62<!-- START CONTENT -->
63<div id="content">
64
65<h1>Database Caching Class</h1>
66
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]67<p>The Database Caching Class permits you to cache your queries as text files for reduced database load.</p>
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]68
admin5ffba1e2006-10-05 04:23:18 +0000[diff] [blame]69<p class="important"><strong>Important:</strong>&nbsp; This class is initialized automatically by the database driver
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]70when caching is enabled. Do NOT load this class manually.<br /><br />
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]71
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]72<strong>Also note:</strong>&nbsp; Not all query result functions are available when you use caching. Please read this page carefully.</p>
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]73
admin11c06c72006-10-05 05:12:27 +0000[diff] [blame]74<h2>Enabling Caching</h2>
75
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]76<p>Caching is enabled in three steps:</p>
admin11c06c72006-10-05 05:12:27 +0000[diff] [blame]77
78<ul>
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]79<li>Create a writable directory on your server where the cache files can be stored.</li>
80<li>Set the path to your cache folder in your <dfn>application/config/database.php</dfn> file.</li>
81<li>Enable the caching feature, either globally by setting the preference in your <dfn>application/config/database.php</dfn> file, or manually as described below.</li>
admin11c06c72006-10-05 05:12:27 +0000[diff] [blame]82</ul>
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]83
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]84<p>Once enabled, caching will happen automatically whenever a web pages that contains database queries is loaded.</p>
85
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]86
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]87<h2>How Does Caching Work?</h2>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]88
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]89<p>Code Igniter's query caching system happens dynamically when your pages are viewed.
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]90When caching is enabled, the first time a web page is loaded, the query result object will
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]91be serialized and stored in a text file on your server. The next time the page is loaded the cache file will be used instead of
92accessing your database. Your database usage can effectively be reduced to zero for any pages that have been cached.</p>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]93
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]94<p>Only <dfn>read-type</dfn> (SELECT) queries can be cached, since these are the only type of queries that produce a result.
95<dfn>Write-type</dfn> (INSERT, UPDATE, etc.) queries, since they don't generate a result, will not be cached by the system.</p>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]96
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]97<p>Cache files DO NOT expire. Any queries that have been cached will remain cached until you delete them. The caching system
98permits you clear caches associated with individual pages, or you can delete the entire collection of cache files.
99Typically you'll to use the housekeeping functions described below to delete cache files after certain
100events take place, like when you've added new information to your database.</p>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]101
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]102<h2>Will Caching Improve Your Site's Performance?</h2>
103
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]104<p>Getting a performance gain as a result of caching depends on many factors.
105If you have a highly optimized database under very little load, you probably won't see a performance boost.
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]106If your database is under heavy use you probably will see an improved response, assuming your filesystem is not
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]107overly taxed. Remember that caching simply changes how your information is retrieved, shifting it from being a database
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]108operation to a filesystem one.</p>
109
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]110<p>In some clustered server environments, for example, caching may be detrimental since filesystem operations are so intense.
111On single servers in shared environments, caching will probably be beneficial. Unfortunately there is no
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]112single answer to the question of whether you should cache your database. It really depends on your situation.</p>
113
114<h2>How are Cache Files Stored?</h2>
115
116<p>Code Igniter places the result of EACH query into its own cache file. Sets of cache files are further organized into
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]117sub-folders corresponding to your controller functions. To be precise, the sub-folders are named identically to the
118first two segments of your URI (the controller class name and function name).</p>
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]119
120<p>For example, let's say you have a controller called <dfn>blog</dfn> with a function called <dfn>comments</dfn> that
121contains three queries. The caching system will create a cache folder
122called <kbd>blog_comments</kbd>, into which it will write three cache files.</p>
123
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]124<p>If you use dynamic queries that change based on information in your URI (when using pagination, for example), each instance of
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]125the query will produce its own cache file. It's possible, therefore, to end up with many times more cache files than you have
126queries.</p>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]127
128
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]129<h2>Managing your Cache Files</h2>
130
131<p>Since cache files do not expire, you'll need to build deletion routines into your application. For example, let's say you have a blog
132that allows user commenting. Whenever a new comment is submitted you'll want to delete the cache files associated with the
133controller function that serves up your comments. You'll find two delete functions described below that help you
134clear data.</p>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]135
136
admin0a35e3d2006-10-06 06:05:02 +0000[diff] [blame]137<h2>Not All Database Functions Work with Caching</h2>
138
139<p>Lastly, we need to point out that the result object that is cached is a simplified version of the full result object. For that reason,
140some of the query result functions are not available for use.</p>
141
142<p>The following functions <kbd>ARE NOT</kbd> available when using a cached result object:</p>
143
144<ul>
145<li>num_fields()</li>
146<li>field_names()</li>
147<li>field_data()</li>
148<li>free_result()</li>
149</ul>
150
151<p>Also, the two database resources (result_id and conn_id) are not available when caching, since result resources only
152pertain to run-time operations.</p>
153
154
155<br />
156
admin5294f4f2006-10-06 02:10:05 +0000[diff] [blame]157<h1>Function Reference</h1>
adminf3428b52006-10-05 05:19:15 +0000[diff] [blame]158
159
160
161
162
163
164
165
166
167
168
169
170
admin43a823e2006-09-27 01:57:10 +0000[diff] [blame]171
172
173</div>
174<!-- END CONTENT -->
175
176
177<div id="footer">
178<p>
179Previous Topic:&nbsp;&nbsp;<a href="call_function.html">Custom Function Calls</a>
180&nbsp;&nbsp;&nbsp;&middot;&nbsp;&nbsp;
181<a href="#top">Top of Page</a>&nbsp;&nbsp;&nbsp;&middot;&nbsp;&nbsp;
182<a href="../index.html">User Guide Home</a>&nbsp;&nbsp;&nbsp;&middot;&nbsp;&nbsp;
183Next Topic:&nbsp;&nbsp;<a href="export.html">Database Export Class</a>
184<p>
185<p><a href="http://www.codeigniter.com">Code Igniter</a> &nbsp;&middot;&nbsp; Copyright &#169; 2006 &nbsp;&middot;&nbsp; <a href="http://www.pmachine.com">pMachine, Inc.</a></p>
186</div>
187
188</body>
189</html>