mysql_free_result()

[Man-wai Chang]

After the webserver executed a page.php (resulting with or without
error), are all $result from mysql_query() released automatically?

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

[Schraalhans Keukenmeester]

Re: mysql_free_resu lt()

Man-wai Chang wrote:

>
After the webserver executed a page.php (resulting with or without
error), are all $result from mysql_query() released automatically?
>

Google

[Man-wai Chang]

Re: mysql_free_resu lt()

Yes, when the script finishes executing. There is a memory leak somewhere

though in mysql_query() and using mysql_free_resu lt() doesn't properly free
all the memory. Unless you are executing thousands of queries in a single
script this shouldn't be a problem. If it is, you can just increase the
available memory size for your script.

Memory leak? What about local variables?

This function reminds me of the RELEASE command in Foxpro. But then, I
never seen a need to use it as long as I declare the variables as LOCAL
or PRIVATE.

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

[Man-wai Chang]

Re: mysql_free_resu lt()

Google

So did you publish your findings and experiences on PHP? If no one
expert talked, what kind of answers could Google found?

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

[Man-wai Chang]

Re: mysql_free_resu lt()

Man-wai Chang wrote:

>Google

>
So did you publish your findings and experiences on PHP? If no one
expert talked, what kind of answers could Google found?
>

And you didn't think Google could read your mind, could you?

--
iTech Consulting Services Limited
Expert in ePOS (Point-Of-Sales) solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

[Schraalhans Keukenmeester]

Re: mysql_free_resu lt()

Man-wai Chang wrote:

>Google

>
So did you publish your findings and experiences on PHP? If no one
expert talked, what kind of answers could Google found?
>

So did you even try and find an answer there yourself? Suppose not.
Sh.

[-Lost]

Re: mysql_free_resu lt()

David Gillen wrote:

Man-wai Chang said:

>After the webserver executed a page.php (resulting with or without
>error), are all $result from mysql_query() released automatically?
>>

Yes, when the script finishes executing. There is a memory leak somewhere
though in mysql_query() and using mysql_free_resu lt() doesn't properly free
all the memory. Unless you are executing thousands of queries in a single
script this shouldn't be a problem. If it is, you can just increase the
available memory size for your script.

Is that Bug #28424? I often wondered if he meant result or query.

--
-Lost
Remove the extra words to reply by e-mail. Don't e-mail me. I am
kidding. No I am not.