UBB threads 7.2 missing index

[ronaldd]

UBB threads 7.2 missing index

We have a UBB threads 7.2 forum with more then 237.000 threads. Importing this forum into vb takes 'forever' on the thread table. The reason for that is, that impex does a ' SELECT importthreadid FROM thread WHERE importthreadid=XXX AND importforumid=1' before each insert,without an index on importthreadid. This means that mysql needs todo more then 237.000 table scans. That makes import unusable.

After creating an index on importthreadid, import time went down from 18 hours to 4 minutes.

Ronald

[Jerry]

This is an effect of the dupe_checking that can be set to "false".

Though adding the index would help either way.

[Jerry]

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