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