PHP mysqli multi query empty results
Im using mysqli multi query to do some inserts and 开发者_JS百科updates in one big lump instead of doing them in lots of seperate queries, basically I don't care about the results even if it is an error and ive read on the PHP.net doc page for the multi_query function I can use this:
while ($mysqli->next_result()) {;}
to go through the results so I can execute more queries. But the problem here seems to be that each loop of that is taking forever to run, if i replace the ; with echo "Next";
its like a half a second between each next being echoed.
Any way i can speed this up, or empty the results or something?
You could try using
UPDATE LOW_PRIORITY ...
And
INSERT DELAYED ...
If you are using the MyISAM storage engine
精彩评论