UBB threads 7.2 missing index Issue Tools
issueid=24684 Wed 27th Feb '08 9:02am
New Member
UBB threads 7.2 missing index
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
Issue Details
Project ImpEx
Category Suggestion
Status Flagged for Future
Priority 5 - Medium
Affected Version 1.86
Fixed Version (none)
Users able to reproduce bug 1
Users unable to reproduce bug 0
Assigned Users (none)
Tags (none)

Thu 26th Jun '08 10:21pm
ImpEx Developer
 
This is an effect of the dupe_checking that can be set to "false".

Though adding the index would help either way.
Reply
Thu 26th Jun '08 10:26pm
ImpEx Developer
 
Reply
Reply