Slow insert

Hi Dung,

Thank you for the debug log, from this it does look like your server takes 7 seconds from after a product has been inserted to importing the next product.

This slowdown could be caused by any number of things as the importer uses the core wordpress and woocommerce methods to insert/update products for compatability reasons, this means that all actions and filters are ran, so depending on what plugins you have installed/active they could be reindexing caches / any labour intensive operations that could be causing the 7 second delay.

To figure out what is causing this slowdown, i would recommend creating a copy of your website, with the default wordpress theme, woocommerce and all import wp plugins, running the import to see if slowdown still exists.

Then installing and activating another single plugin and running the import, repeating this for all plugins each time until you see the import time increase.

Once we know what plugin/plugins are causing it, i can have a look and see what can be done to bypass this to speed the import up.

James

Thanks for your quick response.

Because of over quota of disk usage.I have just found out that the slowdown caused by downloading image when importing.

It is not caused by ImportWP, it is Content Egg plugin (setting: External featured images - Disabled - internal image is used), then it forced ImportWP to download image when importing products. (Even I use external url plugin). I have just change option to use external image to fix the slowdown.

Just to confirm, how have you setup importwp to not download images?

I changed the option in Content Egg's settings - External featured images: from "Disabled - internal image is used" to "Enabled - external image has priority" as the screenshot attached.

then I use Featured Image from URL (FIFU) plugin for external image, use ImportWP to import external image url into "fifu_image_url" custom field.