Announcement

Collapse
No announcement yet.

Dropping an index before importing can speed things up

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

  • Jerry
    replied
    Set, dupe_checking to false in the ImpExConfig as well, that should speed things up even more.

    Leave a comment:


  • Gérome
    started a topic Dropping an index before importing can speed things up

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X