Search & Filter Pro causing WP All Import Pro to take a lot longer to import

Anonymous

#185832

Hi,

I have spent around 4 hours getting to the bottom of a significant slowdown in data importing using wp all import pro. As it turns out it is related to search and filter pro, disabling the plugin makes wp all import work quickly as normal. I have tried toggling some of the settings in search and filter but no luck the only thing that works is deactivating the plugin all together, which is not ideal as you can imagine.

What do i need to do to get these two plugins to work together?

Thanks,
Matt

Trevor

#185839

By the default settings of both plugins, Search & Filter will not normally notice that WP All Import has made any changes to the database. When I last looked at how that plugin worked, it did not run the WordPress save_post() function and instead accessed the database directly. This meant that Search and Filter would not be aware of any changes and so its cache would be out of sync with the posts and post_meta tables.

There was a hook in WP All Import that could be used to run our cache rebuild for each post changed as it was changed.

The hook is called pmxi_saved_post. Are you using this? See this thread for guidance:

https://support.searchandfilter.com/forums/topic/wp-all-import-taxonomies-not-updated/

Anonymous

#186120

Hi Trevor,

Thanks for your response, I am not using that hook. I’m pretty sure i’m just using standard settings, it seems really very odd that simply having it switched on is causing such dramatic performance issues.

Is there any way someone could take a look just to be sure i’m doing things right?

Thanks so much,
Matt

Trevor

#186124

I am sure we can take a look, but if you are not using that hook, is our cache up-to-date after an import (do a search that would yield a new post imported with the import plugin)? It is recommended to use that hook, as otherwise you might have to update the entire cache, and that takes a LOT longer than using the hook.

[Author]

Posts