I migrate a site from wordpress.com to a domain (ulloi129.hu) onto a huge server (4 Xeon, 8Gb ram), but the importing process more often than not brings the whole site down completely, like this morning (while importing a 250k file it ate up all the memory). It is a WP multisite (but currently there's only one blog on it) with Buddypress and about 10000 articles and 400000 comments.
The importing, even when it does work is extremely sluggish, I have to split the WXR export into 300-500k long files.
(The site as a whole eats up memory like a hungry pitbull.)
Is there any solution for this?