Close connection

Hi
Is it important for close connection after query?
Example
$res = $this->db->query('')->result_array();
$this->db->close();

Also i have other question
How do i can delete cache only for special query?
at the moment we can delete all cache

AFAIK, Query builder automatically close the database after use (correct me if I'm wrong)

For special queries, assign your special query to a variable:

PHP Code:

$special_query = $this->db->query(); 


Then if you want to use 

PHP Code:

$this->db->flush_cache(); 


You can still use your special query:

PHP Code:

$special_query->result(); 


But I didn't try this before (but I use query caching a lot), so try it for yourself.