ID: 6598 Updated by: derick Reported By: [EMAIL PROTECTED] Old-Status: Analyzed Status: Closed Bug Type: MySQL related Operating system: PHP Version: 4.0.1pl2 Assigned To: Comments: In php 4.0.5 there is a new function, called mysql_unbuffered_query() which will do this for you. Previous Comments: --------------------------------------------------------------------------- [2000-11-02 07:15:28] [EMAIL PROTECTED] 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. --------------------------------------------------------------------------- [2000-09-07 08:17:14] [EMAIL PROTECTED] 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); ?> --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=6598&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]