v5:userguide:learn_caching:introduction
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
v5:userguide:learn_caching:introduction [2016/03/27 19:25] – created mnewnham | v5:userguide:learn_caching:introduction [2016/03/28 03:10] (current) – mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <- ^ v5: | ||
+ | ~~NOTOC~~ | ||
====== Caching Result Sets ====== | ====== Caching Result Sets ====== | ||
===== Description ===== | ===== Description ===== | ||
- | The concept of caching is simple, in that it provides pre-processed result sets for oft-used queries (often referred to as static data). These result sets can be extracted from the database and provided in some alternate manner. In principle: | + | The concept of caching is simple, in that it provides pre-processed result sets for oft-used queries (often referred to as static data). These result sets can be extracted from the database and be provided |
* Eliminating repeated requests for static data reduces load on the the server and allows it to serve transactional data more efficiently. | * Eliminating repeated requests for static data reduces load on the the server and allows it to serve transactional data more efficiently. | ||
However, in practice, improvements in database servers, disk drives and memory have made it difficult to obtain improvements in performance unless: | However, in practice, improvements in database servers, disk drives and memory have made it difficult to obtain improvements in performance unless: | ||
- | * The performance of the underlying system is extremely poor, for example in Microsoft Access | + | * The performance of the underlying system is extremely poor, for example in Microsoft Access |
* All incremental improvements are considered appropriate, | * All incremental improvements are considered appropriate, | ||
Line 15: | Line 17: | ||
- A traditional, | - A traditional, | ||
- | - A remote | + | - A remote memory caching server based on [[https://memcached.org/ |
- | ===== System Requirements ===== | + | Once implemented, |
- | The directory where the queries | + | |
- | ===== Default Cache Secs ===== | + | |
- | The parameter '' | + | |
- | + | ||
- | This default value can be overridden on a query by query basis | + | |
- | + | ||
- | <code php> | + | |
- | /* | + | |
- | * A connection object assumed | + | |
- | */ | + | |
- | $ADODB_CACHE_DIR = ' | + | |
- | $db-> | + | |
- | </ | + | |
- | + | ||
- | {{tag> | + |
v5/userguide/learn_caching/introduction.1459099519.txt.gz · Last modified: 2017/04/21 11:40 (external edit)