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
Ashley Sheridan wrote: > On Wed, 2010-01-20 at 13:24 -0800, Daevid Vincent wrote: > >> http://www.php.net/manual/en/function.mysql-free-result.php >> >> mysql_free_result($myresult); >> >> NOTE: mysql_free_result() only needs to be called if you are concerned >> about how much memory is being use

RE: [PHP] Close MySQL Result

2010-01-20 Thread Ashley Sheridan
On Wed, 2010-01-20 at 13:24 -0800, Daevid Vincent wrote: > http://www.php.net/manual/en/function.mysql-free-result.php > > mysql_free_result($myresult); > > NOTE: mysql_free_result() only needs to be called if you are concerned > about how much memory is being used for queries that return large

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
http://www.php.net/manual/en/function.mysql-free-result.php mysql_free_result($myresult); NOTE: mysql_free_result() only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. All associated result memory is automatically freed at t