My VB site has 25mm posts and 1.8mm threads

Reeve of Shinra

Well-known member
I believe there is a command line importer which might be best in your case.

Deff go with elastic seach addon. A lot of the time in the conversion process is the reindexing which it helps with.