v5:userguide:learn_caching:introduction
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:userguide:learn_caching:introduction [2016/03/27 19:25] – [Description] 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 ===== | ||
Line 6: | Line 8: | ||
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.txt · Last modified: 2016/03/28 03:10 by mnewnham