I am in the process of working on a project involving the migration of old custom driven cms data into a WordPress powered site.
To do this migration, we have decided to convert the data from the current site into a WXR import file.
The issue we're facing though is that the resulting WXR file is about 100mb in size. (about 10000 posts, of varying types and about 80000 attachments)
The import is obviously a very slow process given a file that size, so my question is:
Does anybody have any experience of importing a file that large?
If so, what can be done to speed up the process? More memory, more cpu? etc?
My current idea is to spin up a large EC2 instance and try the import on there, and then export the resulting MySQL to the final hosting location.