In one of my site, i am using the SERVER cron to get the data from the third party API vai CURL every minute and run the set transient function. It is working fine most of the fine. But when there are many traffic to the site, the DATABASE gets down.
The main problem is the size of the data coming from third party API. It returns the ARRAY data of nearly 1300 products.
Can somebody share the better idea to properly managing the every minute CRON for large data coming from API?