Read data through interface write database timeout problem

There are 1000 product numbers, by the number of one to go to the interface to adjust the product details and then write into the database, the direct write will time out, what good method??

Reply content:

There are 1000 product numbers, by the number of one to go to the interface to adjust the product details and then write into the database, the direct write will time out, what good method??

Get all the information after the one-time episode, if the amount of data is too large can be split up a few times to get, and then BULK insert

The better way is to save the product number (database, Redis, memcahced, etc.), using crontab timing each batch of times to get a number of information into the database, and modify the stored number identification status. The rough point is to modify the PHP process time limit field in the PHP environment configuration.

