When adding a large number of elements, the database gives an error 504 how to deal with it?

Question

PHP

Such a question when adding a large number of objects more than 600, the database gives a 504 error, tell me how to deal with this ... I tried sleep (15) but it does not help. I don't understand what to do.

Answer 1

Possible solutions: increase the value of the PHP max_execution_time parameter or lighten the script.
What is responsible for max_execution_time in 1C, so look for a similar function and try it.
UDP: Bitrix has this parameter. Increase it at least 2 times.

Answer 2

Unfortunately, the script cannot be reduced because I don’t know how, but the value of max_execution_time already costs 120

Answer 3

Option 0: Optimize the script
Option 1: Process in parts
Option 2: Start processing with a console command
Option 3: Change the server configuration