note 52316 added to function.mysqli-stmt-fetch
| From: | andrey@php.net | Date: | Wed, 27 Apr 2005 18:37:30 +0000 |
| Subject: | note 52316 added to function.mysqli-stmt-fetch | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-88650@lists.php.net to get a copy of this message | ||
IMPORTANT note: Be careful when you use this function with big result sets or with BLOB/TEXT
columns. When one or more columns are of type (MEDIUM|LONG)(BLOB|TEXT) and ::store_result() was not
called mysqli_stmt_fetch() will try to allocate at least 16MB for every such column. It
_doesn't_ matter that the longest value in the result set is for example 30 bytes, 16MB will be
allocated. Therefore it is not the best idea ot use binding of parameters whenever fetching big
data. Why? Because once the data is in the mysql result set stored in memory and then second time in
the PHP variable.
----
Manual Page -- http://www.php.net/manual/en/function.mysqli-stmt-fetch.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+52316
Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+52316&report=yes&reason=added+to+the+manual
Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+52316&report=yes&reason=bad+code
Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+52316&report=yes&reason=spam
Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+52316&report=yes&reason=useless
Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+52316&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+52316&report=yes
Search -- http://master.php.net/manage/user-notes.php