php loop 502 Bad Gateway

Question

Good afternoon.

I have a problem with php foreach loop.

I parse xml file ( ~20mb ) using simplexml and then insert data to mysql

in xml are over 37000 items,i must loop 37000 times ,to read data from xml

every 100 iteration i create string like this: insert into my_table values (...)

But i get a 502 error in 10500-st iteration.

I try send string after loop,but get error again:

memory_limit=240 
max_execution_time 500

How can I solve this problem. Thanks and best regards.

Answer 1

I think the problem is that your script is timing out, you can overcome this by using set_time_limit(0) in you script or by changing the max_execution_time in your php.ini:

while(1) {
  set_time_limit(0);
  // do something
}

You also need to increase your memory_limit by editing your php.ini and restart your webserver.

Read documentation for set_time_limit()