ID: 6598
Updated by: derick
Old-Status: Analyzed
Status: Closed
Bug Type: MySQL related
Operating system: 
PHP Version: 4.0.1pl2
Assigned To: 

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 
(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.

 $res=mysql_query("select * from big_table");
 echo $row[0];


ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at

PHP Development Mailing List <>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to