Expire Database Query Cache

[eluser]wapatv[/eluser]
Hi!

We need to use query caching on our project (a database heavy site), but we also need that the cached queries expire.

CI Database Caching Class does not expire, so might not be an option. Is there a way to add CI query cache that expire?

Thanks!

PS: We'll be using CI 2.0

[eluser]WanWizard[/eluser]
Use Phil Sturgeon's cache library (see here).

It has very granular controls, I use it a lot to cache individual queries, or complete model method results (= query + any post processing).

[eluser]wapatv[/eluser]
Great! just what I needed... will give it a try... thanks!