when I try to set Enable SQL Query Caching to Yes and click update it automatically switches back to no. I have tried with both persistent and non-persistent connections.
ExpressionEngine 1.6.3
Build: 20080319
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
May 30, 2008 7:20pm
Subscribe [1]#1 / May 30, 2008 7:20pm
when I try to set Enable SQL Query Caching to Yes and click update it automatically switches back to no. I have tried with both persistent and non-persistent connections.
ExpressionEngine 1.6.3
Build: 20080319
#2 / Jun 01, 2008 10:51am
Hm- let’s see if we can override in the config. FTP, grab system/config.php and open it up. Add:
$conf['enable_db_caching'] = "y";Save, upload. Make sure config.php is writable- usually chmod 666. Any difference?
#3 / Jun 02, 2008 11:08am
Thanks Robin! That worked.
What is the difference between db_caching and sql_caching? I noticed both in the config file. I set both to yes.
#4 / Jun 02, 2008 11:15am
Check the docs for the details- sql_cache is the ‘Dynamic Weblog Query Caching’ while db_caching is the ‘Query Caching’ heading. There are some differences- and if you’re using expirations and such, you may not want to enable the dynamic caching.
That help?
#5 / Jun 02, 2008 11:17am
helps 100%. Thanks again!!
#6 / Jun 02, 2008 11:21am
😉 Good deal. I’ll go ahead and close this puppy out.