Differences

This shows you the differences between two versions of the page.

--- reference:local_cache [2015/08/02 18:04] – created mnewnham
+++ v5:userguide:local_cache [2016/01/17 03:42] (current) – ↷ Page moved from v5:reference:local_cache to v5:userguide:local_cache mnewnham
@@ Line 1: / Line 1: @@
 ====== Caching Result Sets ======
+===== Description =====
+===== System Requirements =====
+The directory where the queries are saved is controlled by the variable [[v5:reference:adodb_cache_dir|$ADODB_CACHE_DIR]]
 ===== Default Cache Secs =====
-The parameter $cacheSecs is this
+The parameter ''$cacheSecs'' sets the default value of the time in seconds that cached queries are saved. If not set then the value is 3600. It can be set via either a normal connection object or a DSN type connection configuration.
+This default value can be overridden on a query by query basis
+<code php>
+/*
+ * A connection object assumed
+ */
+$ADODB_CACHE_DIR = 'd:/queries';
+$db->cacheSecs   = 6000;
+</code>
+{{tag>[cache]}}