Re: [PHP] Close MySQL Result

2010-01-22 Thread Nathan Rixham
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

Re: [PHP] Close MySQL Result

2010-01-22 Thread Michael Schaefer
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

Re: [PHP] Close MySQL Result

2010-01-21 Thread Nathan Rixham
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.

Re: [PHP] Close MySQL Result

2010-01-21 Thread Shawn McKenzie
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

RE: [PHP] Close MySQL Result

2010-01-21 Thread Daevid Vincent
> -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

Re: [PHP] Close MySQL Result

2010-01-21 Thread Robert Cummings
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://

Re: [PHP] Close MySQL Result

2010-01-21 Thread tedd
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

Re: [PHP] Close MySQL Result

2010-01-21 Thread Nathan Rixham
($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

RE: [PHP] Close MySQL Result

2010-01-20 Thread Ashley Sheridan
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? > >

Re: [PHP] Close MySQL Result

2010-01-20 Thread Slack-Moehrle
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

RE: [PHP] Close MySQL Result

2010-01-20 Thread Daevid Vincent
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

[PHP] Close MySQL Result

2010-01-20 Thread Slack-Moehrle
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