Database query caching not working

[eluser]fchristant[/eluser]
hi,

I've been trying to get CI's query caching to work, but got stuck somewhere.

I'm on Debian Linux, have setup the database.php file to enable query caching and I have pointed it to a writable cache dir in my application folder. I do not manually enable/disable query caching anywhere in my code.

When I open a page (which executes 3 queries), I can see the cache result files being written to the dir I specified. The content of these files look good: they contain the result expected. So far, so good.

However, when I refresh the page, this cache is not used at all:

- The profiler shows 3 queries executed (should have been zero!)
- The MySQL query log shows the same
- When I insert new data, it is shown (should not be the case due to cache)

Enough proof to conclude that the cached results are not used at all. Why not?

PS: my test page contains SELECT queries only.