3.6.9<>3.6.9 Impex Painfully Slow

[Typhon]

I'm currently trying to merge (via ImpEx) two forums, but the process is slow to the point that I know something is wrong ... and was wondering if there are any optimization tips geared specifically towards ImpEx.

Forum Specs:

Source Forum:
Threads: 2,486
Posts: 19,919
Members: 6,464

Target Forum:
Threads: 99,905
Posts: 1,127,946
Members: 124,614

I am running a dedicated webserver (2x 2.8 GHz w/ 2GB RAM) and a dedicated DB Server (2x 2.8 GHz w/ 4GB RAM).

The problem?
It took me 107 minutes to import the 6,464 Members.

So are there any tricks to tuning ImpEx? Maybe a cli? I'm already running it as a stand-alone; and have boosted PHP memory already.

Thanks!

[Jerry]

If you're merging it's going to be searching emails and usernames for each user.

When you are doing threads and posts, check this out :

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

[Typhon]

So 107 minutes to get through the Users part of Impex is acceptible because there are 124,614 members in the Target user table?

Ouch! :( I have 3 more mergers after this and they all have ~50,000 users in each source table.

Are there any post import (auto user merge) after the fact so I don't have to do it as a part of ImpEx?

[Jerry]

I wouldn't say it's acceptable, just explaining what's going on.

Create an index on the target board on user.email before doing the import.

Turn off dupe_checking and turn on shortoutput in ImpExConfig.php.