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