Database Abstraction Layer for PHP https://adodb.org/dokuwiki/ 2026-05-16T22:59:21+00:00 https://adodb.org/dokuwiki/ https://adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2016-03-29T02:56:43+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:adodb_coding&rev=1459220203&do=diff Understanding Time-To-Live List Of Tutorials Debugging Problems With Caching Using Cached Queries ADOdb provides replacement functions that look for cached results, instead of querying the database directly. The names of the methods match the normal method names but with the word 'cache' prepended, e.g. * cacheGetOne replaces getOne text/html 2016-03-29T03:00:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:cache_problems&rev=1459220430&do=diff Using ADOdb Methods List Of Tutorials Solving Problems With Caching Solving Problems With Caching Unexpected Results Finding cached result sets is dependent on there being an exact query match on the SQL statement issued, so for example: SELECT code,description FROM table ORDER BY code and SELECT code,description FROM table ORDER BY code ASC text/html 2016-03-28T23:18:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:cache_ttl&rev=1459207137&do=diff Memcached List Of Tutorials ADOdb Method Usage Time-To-Live (TTL) Description The TTL of the query is the amount of time that the results of a query are cached before the results are re-requested from a database. The following sequence of events occurs: * A query is issued via one of the ADOdb text/html 2016-03-28T23:08:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:disk_caching&rev=1459206498&do=diff Introduction To Caching List Of Tutorials Memcached Servers Disk Based Caching To maximize the performance of disk-based caching systems, the cached data should be placed on the fastest available file system, in order of preference: * A memory based file system (ramdisk), examples: * A windows product such as text/html 2016-03-28T01:10:26+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:introduction&rev=1459127426&do=diff Caching Result SetsList Of Tutorials Disk Based Caching 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: text/html 2018-07-16T18:18:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://adodb.org/dokuwiki/doku.php?id=v5:userguide:learn_caching:memcached&rev=1531765138&do=diff Disk Based Caching List Of Tutorials Understanding Time-To-Live Memcached Setup Learn More Configuring Memcached Memcached provides a controlled, server-based memory caching service. The server is reasonably easily configured and installed, but provides a sophisticated caching configuration. PHP support for the library is available through the PHP PEAR