PHP 4.0 Bug #6598 Updated: Memory overflow

ID: 6598 Updated by: stas Reported By: artem@osp.ru Status: Analyzed Bug Type: MySQL related Assigned To: Comments: Well, mysql_use_result is not too nice - it basically ties down your connection and any tables used until the end of the operation... But maybe it should indeed be possible to use this with some parameter to mysql_query. Previous Comments: --------------------------------------------------------------------------- [2000-09-07 08:17:14] artem@osp.ru When I try to get dump of my table (about 5.000.000 records) cause memory overflow. When I check problem, I found, that php always use mysql_store_result(), and never mysql_use_result() (from C API). At mysql (comand line tool) I can use option -q. which forse use mysql_use_result(). I need someting like in php. Maybe as additionall argument in mysql_query, maybe as constant in configuation file, maybe other. <?PHP mysql_connect("localhost","...","..."); mysql_select_db("..."); $res=mysql_query("select * from big_table"); $row=mysql_fetch_row($res); echo $row[0]; mysql_free_result($res); ?> --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=6598