ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
<-  ^ v5:userguide:userguide_index|List Of Tutorials ^ v5:userguide:learn_caching:disk_caching|Disk Based Caching ->
~~NOTOC~~
====== Caching Result Sets ======
===== 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 be provided to the end user in some alternate manner. In principle:

  * 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:
  * The performance of the underlying system is extremely poor, for example in Microsoft Access Databases (although this is a poor solution in the first place for this kind of system). 
  * All incremental improvements are considered appropriate, for example in high-volume OLTP environments.

In this situation, each of the above situations can be considered as a different configuration issue.

===== Solutions From ADOdb =====
ADOdb provides 2 distinct solutions to the underlying configuration:

  - A traditional, simple disk based caching system that can be installed locally
  - A remote memory caching server based on [[https://memcached.org/|Memcached]]

Once implemented, the coding methodologies are the same.