note 95115 added to function.mysql-unbuffered-query
| From: | SylvesterHesp at osu1 dot php dot net | Date: | Mon, 14 Dec 2009 15:11:11 +0000 |
| Subject: | note 95115 added to function.mysql-unbuffered-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-163932@lists.php.net to get a copy of this message | ||
> 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.
----
Server IP: 91.199.167.223
Probable Submitter: 213.201.137.74
----
Manual Page -- http://www.php.net/manual/en/function.mysql-unbuffered-query.php
Edit -- https://master.php.net/note/edit/95115
Del: integrated -- https://master.php.net/note/delete/95115/integrated
Del: useless -- https://master.php.net/note/delete/95115/useless
Del: bad code -- https://master.php.net/note/delete/95115/bad+code
Del: spam -- https://master.php.net/note/delete/95115/spam
Del: non-english -- https://master.php.net/note/delete/95115/non-english
Del: in docs -- https://master.php.net/note/delete/95115/in+docs
Del: other reasons-- https://master.php.net/note/delete/95115
Reject -- https://master.php.net/note/reject/95115
Search -- https://master.php.net/manage/user-notes.php