note 95115 deleted from function.mysql-unbuffered-query by danbrown
| From: | danbrown@php.net | Date: | Mon, 14 Dec 2009 15:58:50 +0000 |
| Subject: | note 95115 deleted from function.mysql-unbuffered-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-163935@lists.php.net to get a copy of this message | ||
Note Submitter: Sylvester Hesp
----
> if the behaviour remains the same,the advantge of the mysql_unbuffered_query is just the
> immediately action rather than saves a considerable amount of memory.
Nonsense, it will still save a considerable amount of memory. The difference with the buffered
variant is that the latter needs to keep all results in memory because you need to be able to access
it. With the unbuffered version, mysql_free_result() will indeed fetch all rows, but it doesn't
need to do anything with the data, so it doesn't need to fit the complete rest of the query
into memory before freeing it. It just "eats" the data, it doesn't store it anywhere.