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]
