[eluser]simonspoken[/eluser]
I've been playing around with caching for the last few hours. Because of the size of our database, it's taking 1.4 seconds for CodeIgniter to execute the index() page.
I turned caching on, and that was a MASSIVE improvement. 0.007 seconds.
Awesome, right? Well, no. Because of the nature of our site, we must store session identifiers in the URL (and therefore in links). However, when regular caching is turned on, the session id's in all links belong to the first user to access the site.
So, I turned to DB caching. I know the cache dir is writable, since I've been using it for the above.
I set up caching in config/database.php and turned it on. 0.6 seconds. I then added:
$this->db->cache_on();
// my active record stuff goes here
$this->db->cache_off();
This still didn't make a difference. I've done a bit of debugging in database/DB_cache.php and know that the cache dir is set correctly in config/database.php
Does anyone know how to make this work? Cheers