Caching Queries

[eluser]JasonS[/eluser]
I have read the documentation. I still have one or two questions.

How long is the duration of a cached item? How do I set it?

Is it possible to caching off by default and only enable it for a couple of queries?

[eluser]Pascal Kriete[/eluser]
The query cache does not expire. You can clear it manually when you update the database using the delete function.

The enabled/disabled functionality is defined in the database.php class, to turn it on for a specific query you would simply call $this->db->cache_on();

It's all in here.