The action "Create a product from a process based on additional fields of a process product" does not work correctly

I get something like this:
[{"id":"100854","price":1293},{"id":"100965","price":1293},{"id":"100853","price":1293},{ "id":"100176","price":602},{"id":"100175","price":1302},{"id":"100177","price":802},{"id ":"100178","price":802},{"id":"95034","price":1193},{"id":"95131","price":1193},{"id": "95122","price":753},{"id":"97191","price":472},{"id":"97190","price":472},{"id":"97184 ","price":472},{"id":"97189","price":472},{"id":"97183","price":472},{"id":"97188", "price":472},{"id":"97186","price":472},{"id":"97182","price":472},{"id":"97187","price ":472},{"id":"97185","price":472},{"id":"96028","price":566},{"id":"96019","price": 1117},{"id":"96020","price":1117},{"id":"95104","price":907},{"id":"95147","price":1282} ,{"id":"96027","price":1402},{"id":"95144","price":984},{"id":"95145","price":984},{ "id":"95146","price":984},{"id":"95143","price":453},{"id":"96024","price":1766},{"id ":"96542","price":1766},{"id":"96021","price":1039},{"id":"96022","price":1039},{"id": "96023","price":1039},{"id":"96640","price":913},{"id" :"96726","price":1337},{"id":"98395","price":1202},{"id":"96727","price":1337},{"id":" 95179","price":661},{"id":"95130","price":661},{"id":"95124","price":661},{"id":"95123" ,"price":661},{"id":"97217","price":1038},{"id":"97218","price":1038},{"id":"97219"," price":1038},{"id":"97220","price":1038},{"id":"95129","price":823},{"id":"95128","price" :823},{"id":"95127","price":823},{"id":"95126","price":823},{"id":"95125","price":823 },{"id":"95033","price":823},{"id":"96545","price":841},{"id":"97434","price":841}, {"id":"96724","price":510},{"id":"96723","price":510},{"id":"96725","price":510},{" id":"95148","price":731},{"id":"97161","price":472},{"id":"97159","price":472},{"id" :"97156","price":472},{"id":"97160","price":472},{"id":"97158","price":472},{"id":" 97155","price":472},{"id":"97157","price":472},{"id":"95030","price":1237},{"id":"96069" ,"price":1237},{"id":"95149","price":1248},{"id":"95031","price":1248},{"id":"95150"," price":1248},{"id":"95032","price":1358},{"id":"95121","price ":1358},{"id":"97171","price":472},{"id":"97170","price":472},{"id":"97167","price": 472},{"id":"97164","price":472},{"id":"97169","price":472},{"id":"97166","price":472} ,{"id":"97163","price":472},{"id":"97168","price":472},{"id":"97165","price":472},{ "id":"97162","price":472},{"id":"94994","price":698},{"id":"97694","price":1248},{"id ":"97180","price":1003},{"id":"97177","price":1003},{"id":"97179","price":1003},{"id": "97176","price":1003},{"id":"97173","price":1003},{"id":"97178","price":1003},{"id":"97175 ","price":1003},{"id":"97172","price":1003},{"id":"97181","price":902},{"id":"97174", "price":902},{"id":"99955","price":852},{"id":"98763","price":268},{"id":"99078","price ":257},{"id":"99079","price":298},{"id":"95602","price":245}]
updating the price of 100 products in one request by the product id in the box, the response time to the request: 0.89 sec on a cold one. Cold means that this is the first request for these products, i.e. their fetch is not in the mysql cache. If you send the request again, then this is already about 0.5. sec. It is important to understand that these are almost ideal conditions without automation for the product and a local machine with 6 processor threads at 2.8 GHz.
There is also a fast parameter in the api. Then the box does not perform the updates that you sent at all, but gives you the task id. When special workers reach the stage of performing updates, the request will be executed and you can get the result of processing by the task id if you need it. With it, you will reduce the response time to ping between servers and engine startup time, which is about 0.1 sec.
If we take your data and my calculations, then 500k products is about 500k/100=5000 requests to api. Considering that everyone will work in 1 second (and your server obviously has a better processor and the response should be faster if the ping between servers is not large). 5000 requests is 5000 seconds ~ 83 minutes. If done in several threads, it can take 10-15 minutes to update all 500k products. You also need to understand that you hardly need to unload all 500k products every hour, and you need to update only those that have undergone some changes. Which reduces 500k items to a few hundred transfers every hour.
But even the transfer of 500k goods per hour in a single thread seems to me quite a normal result. So your words about the fact that boxing won’t pull something seem to me at least not justified, and at most a little offensive)
ps waiting for the results of your tests with your data. The proof that 100 products can be updated in less than 1 second is above.