Like the question says
A:
Yes, simply unset() the result object.
The result object will then call mysql_free_result
()
e.g.
// $result now holds a Datbase_Result object
$result = Database::instance()->query('SELECT * FROM table');
// To free the result, simply destroy the variable through means of unset()
unset($result);
// Result memory has now been freed
Matt
2009-08-12 20:59:37