Support » Plugin: WooCommerce » Import is taking 20-40+ hours for Variable products

  • Resolved Krammig

    (@krammig)


    Thanks for reading ;

    I have tried several plugins including WP All Import and all are taking an extraordinary amount of time to import. Not the plugins fault I believe.

    For example I am currently trying to import 239 Variable (new) products. So far I am up to record 32 and it has been 5 hours 7 minutes. Trying to run an Update for pricing is just not worth doing it just stalls/runs for days.

    Using other systems I have on other servers running with MSSQL I never experience anything like this. My feeling is the issue relates to the way WordPress handles data and tables. There must be a way to have PHP / WordPress / Woocommerce run well mySQL ?? Isn’t there ??
    Or, as I have read should I try and get this migrated to MSSQL. Is Maria DB an option ?

    Questions.

    a) Can I speed this up by adding Indexes to any tables and if so which ones and what types of index on what fields.

    b) Tables
    _options 29024
    _posts 124572
    _postmeta 1340644

    Products 4,900
    Average products has about 5 colours and 10-15 sizes

    Any help would be greatly appreciated,

    Thanks

    As far as I know I am using INNODB
    PHP 7.1
    mySQL 5.6
    Wordpress 4.9.6
    Dedicated Server running Windows
    CPU 3.53GHZ
    RAM 32GB with 4GB allocated to PHP and 4GB allocated to mySQL and this job.

Viewing 1 replies (of 1 total)
  • Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    If you’re seeing this across multiple plugins, then it’s likely your server’s resources that are the bottleneck here. You should have at least 64 MB allocated in the wp-config.php file – and more doesn’t hurt.

    If you’re still having trouble with this, I recommend reaching out to your host to discuss the server resources.

Viewing 1 replies (of 1 total)
  • The topic ‘Import is taking 20-40+ hours for Variable products’ is closed to new replies.