note 100866 rejected from function.mysql-unbuffered-query by danbrown
| From: | danbrown@php.net | Date: | Thu, 11 Nov 2010 19:35:17 +0000 |
| Subject: | note 100866 rejected from function.mysql-unbuffered-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-173958@lists.php.net to get a copy of this message | ||
Note Submitter: crhatfield at gmail dot com
----
It seems mysql_unbuffered_query() won't let you insert data while you query a table, even if
you're using 2 different link ID's - one for the select and one for the insert.
I'm using mysql_unbuffered_query() to select apx 5 million rows, convert data with PHP and then
trying to insert into new table and mysql_query() runs me out of ram.
Any suggestions?