PHP 4.0 Bug #6598: Memory overflow
| From: | artem at osp dot ru | Date: | Thu, 07 Sep 2000 12:17:14 +0000 |
| Subject: | PHP 4.0 Bug #6598: Memory overflow | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-32533@lists.php.net to get a copy of this message | ||
From: artem@osp.ru
Operating system: Linux
PHP version: 4.0.1pl2
PHP Bug Type: MySQL related
Bug description: Memory overflow
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);
?>