note 95115 added to function.mysql-unbuffered-query

From: 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

« previous php.notes (#163932) next »