We're currently running a Wordpress site but need to import 10,000 - 20,000 posts per day from CSV files. Our current setup is an all-in-one LAMP server with 8GB RAM and 8 Virtual Cores. The import speed is quite slow, taking hours and hours.
My question is, will separating the MySQL server from the LAMP server yield any improvements in import speed? Our site isn't running slow or stalling during the import, it's just the import speed we want to improve.