ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:userguide:learn_caching:adodb_coding

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
v5:userguide:learn_caching:adodb_coding [2016/03/29 01:20] mnewnhamv5:userguide:learn_caching:adodb_coding [2016/03/29 01:22] mnewnham
Line 1: Line 1:
-<- v5:userguide:learn_caching:cache_ttl|Understanding Time-To-Live ^ v5:userguide:userguide_index|List Of Tutorials ^  ->+<- v5:userguide:learn_caching:cache_ttl|Understanding Time-To-Live ^ v5:userguide:userguide_index|List Of Tutorials ^  v5:userguide:learn_caching:cache_problems|Debugging Problems With Caching->
 ~~NOTOC~~ ~~NOTOC~~
 ====== Using Cached Queries ====== ====== Using Cached Queries ======
Line 15: Line 15:
 $sql = 'SELECT code,description FROM xref_table'; $sql = 'SELECT code,description FROM xref_table';
 $db->cacheExecute(2400,$sql); $db->cacheExecute(2400,$sql);
- 
- 
- 
 </code> </code>
-===== Using Debug Mode  ===== 
-The size of query results that can be cached by the memcached server is limited by server configuration. The default is quite small. If the query is too large, and [[v5:reference:debug|debugging]] is enabled, then an error is displayed. 
- 
- 
-  3849805e4e026b9e7c485999a24a95c6 cache failure: Item with such key doesn't exists on the memcached server. 
-  (this is a notice and not an error) 
-  -----<hr> 
-   
-  (mysqli): SELECT * FROM employees  
-   
-  -----<hr> 
-  Notice: MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with: 
-  SERVER_ERROR object too large for cache 
-  (3) in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94 
-  Failed to save data at the memcached server! 
-   
-  Cache write error 
-   
-  PHP Notice:  MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with: 
-  SERVER_ERROR object too large for cache (3)  
-  in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94 
-   
-ADOdb currently has no mechanism for splitting large queries into smaller chunks. 
- 
  
-{{tag>[memcached cache]}} 
v5/userguide/learn_caching/adodb_coding.txt · Last modified: 2016/03/29 04:56 by mnewnham