note 57564 added to function.mysqli-stmt-bind-result

If you select LOBs use the following order of execution or you risk mysqli allocating more memory that actually used 1)prepare() 2)execute() 3)store_result() 4)bind_result() If you skip 3) or exchange 3) and 4) then mysqli will allocate memory for the maximal length of the column which is 255 for tinyblob, 64k for blob(still ok), 16MByte for MEDIUMBLOB - quite a lot and 4G for LONGBLOB (good if you have so much memory). Queries which use this order a bit slower when there is a LOB but this is the price of not having memory exhaustion in seconds. ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-stmt-bind-result.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+57564 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+57564&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+57564&report=yes Search -- http://master.php.net/manage/user-notes.php