Announcement

Collapse
No announcement yet.

Dropping an index before importing can speed things up

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dropping an index before importing can speed things up

    I am importing a quite heavy modified phpBB2 to vB 3.7.
    Importing the posts takes most of the time, in my case about two hours.

    After deleting the fulltext-index 'title' (title, 'pagetext') from the vb-posts table the import only takes 20 minutes. re-creating this index after the import took about 4 minutes.

    Of course i do not know anything about the other systems ImpEx supports, but at least for phpBB2 the existence of this fulltext-index is not vital while importing the data.


    Maybe this could be an aspect of optimizing the time an import takes.


    kind regards,
    Gérome

  • #2
    Set, dupe_checking to false in the ImpExConfig as well, that should speed things up even more.
    I wrote ImpEx.

    Blog | Me

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X