if your query is within a loop then it would probably help, e.g.
for ($i = 1; $i <= 1000; $i++)
{ $result = mysql_query("...");
...
}
in this case as $result is a resource identifier then reusing
it doesn't release the original result.
Tim Ward
www.chessish.com
> -----Original Message-----
> From: Support @ Fourthrealm.com [mailto:[EMAIL PROTECTED]]
> Sent: 19 September 2002 01:18
> To: [EMAIL PROTECTED]
> Subject: use of mysql_free_result (was Re: [PHP] Efficiency)
>
>
> Rick, or anyone,
>
> Based on what you said below, can you describe for me when the
> mysql_free_result tag should be used, and when it is not necessary?
>
> I'm fluent in other web languages (iHTML, ASP), but am fairly
> new to PHP,
> so I'm still learning the intricacies of the language, and
> the best way to
> use it
>
> Many thanks,
> Peter
>
>
>
> At 04:02 PM 9/18/2002 -0600, you wrote:
> >If you aren't doing anything else in a script,
> mysql_free_result is not needed
> >in a script like this because the result set will be cleaned
> up by PHP when
> >the script ends.
>
> - - - - - - - - - - - - - - - - - - - - -
> Fourth Realm Solutions
> [EMAIL PROTECTED]
> http://www.fourthrealm.com
> Tel: 519-739-1652
> - - - - - - - - - - - - - - - - - - - - -
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
