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

[PHP] Freeing Memory

2009-07-30 Thread Anton Heuschen
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 after each array

[PHP] Freeing memory for DOMDocument

2009-01-07 Thread Christoph Boget
I'm running through a large dataset and am generating/manipulating XML documents for each record. What's happening is that after a while, I get a fatal error saying: Fatal error: Allowed memory size of 167772160 bytes exhausted (tried to allocate 32650313 bytes) Each XML file I generate (an mani

[PHP] Freeing memory WAS emalloc() error being thrown {LONG} - MORE

2003-06-24 Thread Jay Blanchard
***pulling out what's left of my hair*** I have a situation where I open a new file, do a query, write to the file, close the file, and then start over again at opening a new file while looping through an array. As I do this I can watch memory resources approach 0, ultimately failing the script be