Re: [Mantisbt-dev] How to free DB result?

[Sean C. <se...@ca...>]

This function is called when performing large queries, and the developer is worried about resource consumption.

For instance, if I select a million rows, and then want to select another million rows, but don't have to make the two relate, and also don't have the resources to hold both data sets, I can call mysql_free_result(...) to "deconstruct" the first set, freeing the resources.

PHP automatically does this at the end of execution, or when the resource falls out of scope (garbage collector).

The only case where I can think mantis would possibly need to do this manually is if we select a large number of rows, twice, which is unlikely in this application.

It's like calling mysql_close(...); it's almost always unnecessary, because PHP's excellent garbage collector does it for you.

S

On Wed, Apr 30, 2003 at 10:53:13AM -0500, Kenzaburo Ito wrote:
> http://www.php.net/manual/en/function.mysql-free-result.php
> 
> It's freed at termination of the script.  I've never seen a need to free db
> results explicitly in the scripts. If a situation may warrant it, please feel
> free to explain.
> 
> -Ken
> 
> >> > I wonder in core/database_api.php is no function for freeing database
> >> > result. Am I missing something or results are freed automatically?
> >> All memory / resources are automatically freed when the script terminates.
> >> You should free explicitly when you are allocating a lot of memory (eg.
> >> acquiring a resource in a loop) or when using a limited resource.
> >
> > Actually I know how PHP or CGI scripts works.
> >
> > My question was regarding to this:
> >
> > $ find ./ -type f -exec grep -Hi mysql_free_result {} \;
> >
> > Running this command on Mantis source shows, that there is never
> > mysql_free_result() function called. So my question is, how are database
> > results freed.
> >
> > I'm not asking about freeing other variables/resources, just database
> > results.
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Mantisbt-dev mailing list
> Man...@li...
> https://lists.sourceforge.net/lists/listinfo/mantisbt-dev