Re: [PHP] Freeing Memory

2009-07-31 Thread Nisse Engström
On Fri, 31 Jul 2009 07:54:13 -0400, Dan Shirah wrote: >> >> How does that work considering that mysql_query() only >> returns true or false on INSERT? I'd expect the script >> to fail on $result not being a valid resource. >> > > I don't know about mysql as I work with MSSQL Server and Informix,

Re: [PHP] Freeing Memory

2009-07-31 Thread Dan Shirah
> > How does that work considering that mysql_query() only > returns true or false on INSERT? I'd expect the script > to fail on $result not being a valid resource. > I don't know about mysql as I work with MSSQL Server and Informix, but for me it works like this: $insert = ifx_prepare("INSERT

Re: [PHP] Freeing Memory

2009-07-31 Thread Nisse Engström
On Thu, 30 Jul 2009 10:42:26 -0400, Dan Shirah wrote: > I don't know what version of SQL you are using, but I have found that using: > > mysql_free_result($result); > mssql_free_result($result); > ifx_free_result($result); > > Helped my queries run much faster and use less resources. I had somet

Re: [PHP] Freeing Memory

2009-07-30 Thread Dan Shirah
> > How would you go about ensuring the memory is not exhausted when running a > script ? > > I have a script, which to make it basic ... reads values from files, I > create an array of values per file then with a foreach insert values into a > table, I have added a line to echo the memory use aft