wp_options > wc_facebook_google_product_categories

  • Resolved patrickhs

    (@patrickhs)


    4 years ago

    We started having a ton of 503 errors on the backend of our website so I opened a support ticket with our host. They evaluated our site and this was a significant factor in their response: “The database’s options table is a bit bloated and could use optimizing and the Autoload in your database is a bit large at 1.21MB.”

    So, when looking at wp_options I see that wc_facebook_google_product_categories is approximately 0.71MB of the total 1.21MB being used. How can we optimize this plugin to get rid of the issue rather than having to get rid of the plugin?

    We’re using plugin version Version 2.1.4 on WooCommerce 4.7.0 – PHP Verion 7.4.3

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Simon

    (@simonskyverge)

    Hi all!

    Thanks for raising this issue, and thanks for the feedback so far. The option was created for the Google Product Category implementation, to allow specifying this for your synced products to help avoid errors in Commerce Manager and allow for better ad creation.

    The list of categories itself is causing this to be a large option value as you’ve seen. We’ve raised this with our developers to see what improvements we can make to the implementation to avoid these types of issues going forwards, sorry once again for the problems this is causing!

    While there isn’t a fix for this in the short term, it would be possible to revert back to plugin v2.0.5, before the categories were added, and remove the database option.

    I’m sorry this isn’t the best news at this time! Is there anything else I can help out with?

    Cheers,

    Simon.

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    If a developer would like to contribute to the plugin to help with this optimization please use the GitHub repository to do so:

    https://github.com/facebookincubator/facebook-for-woocommerce

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘wp_options > wc_facebook_google_product_categories’ is closed to new replies.