deleting database cache after some time codeigniter

Question

I was wondering if there is any workaround to delete database cache in codeigniter, say after every 5 hours. by default database query cache is persistent and we have to delete it manually.

Can we make db cache work like page level cache in CI, where we can specify time for cache!

Answer 1

You could make a cron script to call $this->db->cache_delete_all(); and run it every 5h.