开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜