Snitz -> vBulletin - Very Slow

[tbit]

Hello,

I am currently trying to move a Snitz Forum over to vBulletin (latest version) but the impex import is extremely slow.

Here are some background infos:

Snitz Forum (MSSQL (converted to mySQL)
100.000 Members
1.3 Million Posts
180.000 Threads

I converted the MSSQL Database to mySQL as my server did not support MSSQL for PHP. Imported the SQL dump into a clean database (source) and setup a second database (target)

I am running impex as standalone version. Have assigned 2GB of RAM to php processes and a timout limit of 10 minutes. I think this is enough ram and resouces for the import.

The Member import took around 5 hours.
The Thread import over 24 hours.
The Post import (currently at around 250.000 posts) more than 40 hours so far.

The import is running on a multi-processor cluster system. I rebuild the database indexes, removed postid FULLTEXT from Indizes (table wfpost) and anything else I thought could speed up the process.

Can anyone help or does anybody know what may cause this very slow import?

Thanks.

Tom

[Jerry]

You've done all the steps here ?

http://www.vbulletin.com/docs/html/med_large_import

At which point does it seem to be paused/waiting the most ?