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 something
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 INTO
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, but for
me
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
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
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
***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
7 matches
Mail list logo