Hi,
I can start right now.
I have read your exact requirements and understood the issue of server load when CSV updated.
I will fix it as per your guidance, please share the Root SSH.
I will follow these steps:
-- I will check the exact causing of server load during CSV updating and will fix it.
-- After tha, I will optimize the complete site and server so the load time will be more reduced and site won't be crashed.
-- After that, I will set up Varnish and Redis Cache which is very good for server load.
-- I will setup and do configuration of CDN and for this site load time will be more decrease.
I have a single query:
-- Are you using NGINX web server or Apache?
if we will use NGINX, then it's also control the server crashed from high load.
please feel free to ask me if you have any more doubt.
I have +8 years of experience in Magento and also have +5 years of experience as a Linux Administrator.
Regards
Rohit