Importing large Vanilla Forum to bbPress – Speed
I’ve been trying to import my vanilla 2 forum posts (just under 500000 replies) and it’s been working away for a very very long time. Tried to do it on the server as well as locally on my macbook pro running Mountain Lion. It seems that it’s even running slower locally than on my server and after leaving it to run for a couple of days, I’m about 1/4 of the way there.
Tried all kinds of delay times and row limits but I can’t find a way to improve the speed of the import.
I was wondering if anyone here has successfully imported a database this size and has tips on how to speed up the process? Even at a 200 Limit with 3 second delay my MySQL workbench on my local machine shows 11000 Queries/second which seems a bit high?
I’m using the latest versions of bbpress, wordpress and vanilla.
- You must be logged in to reply to this topic.