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:
However, in practice, improvements in database servers, disk drives and memory have made it difficult to obtain improvements in performance unless:
In this situation, each of the above situations can be considered as a different configuration issue.
ADOdb provides 2 distinct solutions to the underlying configuration:
Once implemented, the coding methodologies are the same.