conversion toooooooo slow from ipb2.1.7

[yawp]

Hi folks,

I'm migrating a huge ipb2.1.7 forum database to smf1.1.8. The conversion goes smoothly through forums, members, topics, posts and when it comes to private messages it takes ages!! it took nearly 36 hours to convert 450.000 private messages in the first attempt.

is this normal ? and in that case, is there any way to speed up the conversion ?

[ThorstenE]

yeah, I know this .. the main issue: our converter is using a JOIN statement for the polls table from IPB and there is no index set to the related table field.

You can add a index to the IPB polls table (this will increase the speed up to 100x ).

Code Select Expand

ALTER TABLE `ibf_polls` ADD INDEX ( `tid` );
(replace ibf_ with your database prefix)

Note: Make a backup from your IPB before you change the table layout!

[yawp]

thanx for the quick reply TE. I created that index, but i did not do any good to improve speed. the conversion is still stuck on message 12500/450.000 and it's been 1 hour. and no error messages on apache or mysql logs, neither on the convertor page.

by the way, the ibf_polls tables has only 36 records and i think even with no index on the 'tid' field it would be quicker.

any other suggestions ?

[ThorstenE]

I believe the column "mt_msg_id" from table "ibf_message_text" has no index set?

you can add an index with:

Code Select Expand

ALTER TABLE `ibf_message_topics` ADD INDEX ( `mt_msg_id` );

Don't forget: Backup before!