database caching with codeigniter problems

php sql caching codeigniter database-caching
Bill picture Bill · Feb 19, 2011 · Viewed 8.4k times · Source

I've just built a site using codeigniter and mysql. It works great, but I want to turn the database caching on. I figured I would just do it globally rather than caching each select statement manually. in my database config file, I set 'cache_on' = TRUE and then for the 'cachedir' = "http://www.mydomain.com/application/cache/dbcache"

I set the whole cache directory as writable, so I think everything is set up correctly. After loading a few pages, I looked back into the cache directory, and it's still empty. I'm assuming that means that nothing was cached. Am I missing something? I'm not getting any errors and all my select statements are showing the results. What am I doing wrong / and how can I tell if the caching is working?

Thanks!

Answer

jfoucher picture jfoucher · Feb 19, 2011

You need to use a relative path, not a url.

Try changing cachedir to application/cache, like so:

$db['default']['cachedir'] = 'application/cache';

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL query String contains

I've been trying to figure out how I can make a query with MySQL that checks if the value (string $haystack ) in a certain column contains certain data (string $needle), like this: mysql_query(" SELECT * FROM `table` WHERE `column`.contains(…

Read More
How to 'insert if not exists' in MySQL?

I started by googling, and found this article which talks about mutex tables. I have a table with ~14 million records. If I want to add more data in the same format, is there a way to ensure the record I …

Read More