Huge postmeta bloat

I’ve had to deactivate this plugin after discovering it had created over 2.9 million postmeta entries using the meta key _faire_product_sync_result.

This caused our WooCommerce Products admin page to stop loading entirely, as the size of the postmeta table grew so large that WooCommerce’s standard admin queries (which join wp_postmeta several times) could no longer complete without exhausting memory.

To prevent this from happening on other sites, I’d recommend that the plugin either:

1. Stores only one meta entry per product/variation, updating it as needed (instead of creating new rows each time), or
2. Creates a custom database table for logging sync results, instead of storing them in wp_postmeta, which is a shared and performance-critical table for WooCommerce.

This would help ensure the plugin doesn’t silently degrade performance or break admin functionality on stores with even modest product counts.

• This topic was modified 1 year, 2 months ago by Recast Digital.
• This topic was modified 1 year, 2 months ago by Recast Digital.