Is there A table A, about 7 w - 10 w the amount of data, I need each process and then returns the value of B is inserted into A table, so need to cycle 7 w w - 10 times to complete; Now I update the data in the article 7 w with the update cycle need nearly four hours to complete, the average per 5 data, is there any way to improve the efficiency, shorten the update time ~!!!

CodePudding user response:

Batch processing, no cycle