Add Feed link takes over 10 minutes to Load

Hello Jeremy,

Best thing to do is install a plugin like “P3 (Plugin Performance Profiler)”, activate it and open it in the “Tools” tab. Then press the “Start Scan” and see what it reports.

If that is not showing any issues, install and activate the plugin “Query Monitor” from “John Blackbourn & contributors”. It will show a queries status bar in the top bar. Open the Add Feed page and see if you can identify the issue there.

Let me know the results.

Best regards,
Michel

Thanks for the reply.

So, I tried the P3 plugin, it really did not give me much, not a very big fan of it. I do use the Query monitor plugin all the time. I ran it and this is what I got, I looked at all the data and cannot see anything that sticks out.

Page Generation Time
548.1319
91.4% of 600s limit

Peak Memory Usage
164,633kB
62.8% of 262,144 kB limit

Database Query Time
0.0257

I think its interesting to note it barely did much with the database at all. I also deleted most of the products and only have 2,000 currently, and it seems to have no bearing on the amount of products I have.

I have your plugin installed on another instance and it works great, but cannot figure out what could be jamming it up on this one. I really want to use it because I am familiar with it, but cannot figure out why it takes that long to load.

One thing, I noticed once it loads, it works fine. The plugin seems to have a Bunch (thousands) of old attributes loaded in it, that no longer exist in the catalog. Could the long load time have something to do with bringing these in, where can I go to clear these out? The attributes aren’t in my system anymroe so not sure where they are even coming from.

And if you select the Query monitor and then the “Queries” option, then sort them by time; which query is on top of the list and what is the time it takes to run it?

You could also try to check the following queries on your database to see if there are attributes that should not be in the database anymore and maybe remove them using a delete query:

– SELECT DISTINCT meta_value FROM wp_postmeta WHERE meta_key = ‘_product_attributes’
– SELECT attribute_name, attribute_label FROM wp_woocommerce_attribute_taxonomies
– SELECT DISTINCT meta_key FROM wp_postmeta WHERE meta_key NOT BETWEEN ‘_’ AND ‘_z’ ORDER BY meta_key

Be aware, I used the wp_ as table prefix, if you’re data uses an other prefix you need to change that in the queries above.

Hello Jeremy,

Where you able to sort out the cause of this issue?

Best regards,
Michel

Hello Jeremy,

I hope we were successful in helping you resolve your issue with WooCommerce Google Feed Manager! Since we have not heard back from you in the past 2 weeks I will now be marking this support topic as resolved. However, if we still haven’t resolved your issue please reach out to us as we would be more than happy to further assist you!

Thanks and have a great day!
Michel