Login

msdcorporation · 11-14-2018, 11:05 AM

(11-14-2018, 10:53 AM)php_rocs Wrote: @msdcorporation,

A couple of questions... What is your timeout value? How much data, on average, is being pulled. I get the feeling that something is wrong because I'm able to do a JSON call in 40K+ records in seconds. What version of PHP, CI and MySQL are you running?

I have JSON file for the 20000 products, and I call the function which is updating a few tables in the database. That function communicates with woocommerce tables and I need to create images as one of the steps in the whole process. My PHP version is 7.1 on MariaDB 5.6 and I think that the execution timeout is about 30sec.

When I call this function with 20000 items in JSON data function work in full time but I have about 1500 items in the database, but if I split those data to 20 files of 1000 items and call every file one by one I have all 20000 items in the database.

I think that it is a little bit clear now the whole scenario.

Thanks again for the advice and assistance...