Why should I free the result of PHP and MySQL?

Why should I free the result of PHP and MySQL using mysql_free_result()?

And what is the difference whether I free开发者_运维问答 the result or not?

Should I always free the result from a MySQL query result specially in CRUD?

Thanks for answering my questions?

Freeing results in PHP is more or less to tell both the server and PHP to drop the resultset returned from a query. It is sort of a mean to free up memory especially when you have many queries or queries that return large resultsets.

On exit, your script cleans up your results automatically. In a web environment it's only necessary if you've extremely limited memory constraints.