Suggestion: Index for importthreadid

[Cars2007]

I was importing 3.0 to 3.7. 2000 posts would take a minute and a half. WAY too slow!

Then I did this:

alter table vb3_thread add index idx_importthreadid (importthreadid);Now, it does 2000 posts in about 7 seconds :)

[Jerry]

Why are you importing between vBulletin versions, that is not what ImpEx is for.

[Cars2007]

Why are you importing between vBulletin versions, that is not what ImpEx is for.
Isn't one of the purposes of ImpEx to allow merging multiple forums into one? :confused:

I also used it once to sanitize a forum that was on a machine that had been hacked.

[Jerry]

Ah it was a merge.

[Cars2007]

This seems to have sped it up a bit more:

alter table vb3_post add index idx_importthreadid (importthreadid);
Now it is doing 5,000 posts per 10 seconds.