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
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 s
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.
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() {
>> $re
> -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 stu
tedd wrote:
At 1:20 PM -0800 1/20/10, Slack-Moehrle wrote:
I think I am a dork.
Aren't we all?
Speak for yourself dork!
;)
Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://
At 1:20 PM -0800 1/20/10, Slack-Moehrle wrote:
I think I am a dork.
Aren't we all?
tedd
--
---
http://sperling.com http://ancientstones.com http://earthstones.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
($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
>>>
>>> I think
ailto:mailingli...@mailnewsrss.com]
> > Sent: Wednesday, 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?
> >
Daevid,
Thanks for the links so I can read up!
-ML
- Original Message -
From: "Daevid Vincent"
To: php-general@lists.php.net
Cc: "Slack-Moehrle"
Sent: Wednesday, January 20, 2010 1:24:16 PM
Subject: RE: [PHP] Close MySQL Result
http://www.php.net/manual/en
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
> Subjec
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
12 matches
Mail list logo