How to optimise lot of entries in database

Hi @kinduweb,

Thanks for reaching out. Happy to help you with this!

The last couple of updates included some additional processes to do a bit of cleanup, so this is not the norm going forward. In addition, your “Action Scheduler” list should automatically remove completed entries older than a month, so they’ll fall off shortly.

Since the plugin’s product feed file is regenerated every 15 minutes, you’ll certainly have a number of these in there for any given month – that’s about 2800 per month. If your products aren’t updated as frequently, we do have a code snippet that I’d be happy to share that allows you to change the frequency of this update.

Would you please let me know if this is helpful and if there’s anything else I can help with?

Thanks,
Marcus

Hey @kinduweb,

Thank you for the kind words! We have a custom code snippet that should do what you’re looking for here, so I’m happy to share it. However, please be aware of a couple notes:

• I’m afraid that customizations are not covered under our support policy, so implementing this directly or modifying it further isn’t something we can assist with.
• Please be sure you know how to add custom code to your site. Personally, I like the free Code Snippets plugin method.

You can view the snippet here:
https://github.com/skyverge/wc-plugins-snippets/blob/master/facebook-for-woocommerce/change-feed-file-generation-interval.php

Once you add and activate this snippet, you’ll need to navigate to your Tools > Scheduled Actions settings page and cancel the last wc_facebook_regenerate_feed item (which should be “pending”) so that a new schedule can be automatically created with the new interval.

Would you please give this a try and let me know if this works for you?

Thanks,
Marcus