> -----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 results
Do you have any proof of this? What would be the logic here? Got some example benchmarks? Got a URL of a whitepaper or something that discusses this? I would think the only things that the mysql calls are doing is holding pointers to the next record and DB handle. I can't imagine they are using that much resources, nor would they be just spinning and waiting tying up CPU cycles either. I've never heard this to be the case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
