note 100866 added to function.mysql-unbuffered-query

From: Date: Thu, 11 Nov 2010 18:47:09 +0000
Subject: note 100866 added to function.mysql-unbuffered-query
Groups: php.notes 
Request: Send a blank email to php-notes+get-173955@lists.php.net to get a copy of this message
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? ---- Server IP: 64.71.164.2 Probable Submitter: 75.135.220.211 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-unbuffered-query.php Edit -- https://master.php.net/note/edit/100866 Del: integrated -- https://master.php.net/note/delete/100866/integrated Del: useless -- https://master.php.net/note/delete/100866/useless Del: bad code -- https://master.php.net/note/delete/100866/bad+code Del: spam -- https://master.php.net/note/delete/100866/spam Del: non-english -- https://master.php.net/note/delete/100866/non-english Del: in docs -- https://master.php.net/note/delete/100866/in+docs Del: other reasons-- https://master.php.net/note/delete/100866 Reject -- https://master.php.net/note/reject/100866 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#173955) next »