Interesting, I don't have any numerical benchmarks, but I saw a
performance benefit moving my result set into an array.
My case may have been extreme, I was creating a table 350 rows by 350
columns, several megabytes of output, and I found that building the
output directly from the query too
Always found the same myself on large datasets and when working with
high traffic sites; but cant replicate in a non-live environment or with
simple grinder style tests; so just follow the procedure as standard
practise in all my code now - likewise with dropping keep alive times on
apache servers
, January 20, 2010 1:21 PM
To: php-general@lists.php.net
Subject: [PHP] Close MySQL Result
I think I am a dork.
How do I close a MySQL result set to free memory?
Given something like this:
$gsql = Select * from resources where queryName = 'Production';;
$myresult = mysql_query($gsql) or die
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
$results[] = $row;
}
close stuff
work on
Daevid Vincent wrote:
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
$results[] = $row;
}
Shawn McKenzie wrote:
Daevid Vincent wrote:
-Original Message-
From: Nathan Rixham [mailto:nrix...@gmail.com]
you'll also find a performance upgrade if you load all sql
results in to
an array and close up the query / free the results before
working on them.
query
for() {
I think I am a dork.
How do I close a MySQL result set to free memory?
Given something like this:
$gsql = Select * from resources where queryName = 'Production';;
$myresult = mysql_query($gsql) or die('Cannot execute Query: ' . mysql_error());
$Row = mysql_fetch_assoc($myresult);
if
at the end of the
script's execution.
http://us2.php.net/manual/en/function.unset.php
unset($Row);
-Original Message-
From: Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Wednesday, January 20, 2010 1:21 PM
To: php-general@lists.php.net
Subject: [PHP] Close MySQL Result
Daevid,
Thanks for the links so I can read up!
-ML
- Original Message -
From: Daevid Vincent dae...@daevid.com
To: php-general@lists.php.net
Cc: Slack-Moehrle mailingli...@mailnewsrss.com
Sent: Wednesday, January 20, 2010 1:24:16 PM
Subject: RE: [PHP] Close MySQL Result
http
:21 PM
To: php-general@lists.php.net
Subject: [PHP] Close MySQL Result
I think I am a dork.
How do I close a MySQL result set to free memory?
Given something like this:
$gsql = Select * from resources where queryName = 'Production';;
$myresult = mysql_query($gsql) or die
10 matches
Mail list logo