when should I use mysql_free_result() ??

[Anon]

Do I have to free a query before I send another one? just like
$query_id = mysql_query("SELECT whatever", $link_id);
mysql_free_result($query_id); //do I need to have this??
$query_id = mysql_query("SELECT something_else");

[[deleted]]

You don't necessarily need to use it since it is all freed at the end of the script. But, as an example, I use it in a very long running script of mine that makes lots of queries. I had to bump up the script execution time from the default so this script would run. This particular script makes about 100 queries from 6 different databases. I free each result when I am done with it just to make sure memory isn't an issue.....

Matt Wade
codewalkers.com

[greg252]

Unless I'm mistaken, mySQL docs say that a result set of 10,000+ records would make it necessary to free the results just for memory consumption sake.