Home Forums Plugins Aliexpress Dropshipping and Fulfillment for WooCommerce Critical: Database Bloat and “Heavy” Duplicate Queries in ALD

Critical: Database Bloat and “Heavy” Duplicate Queries in ALD

  • Author
    Posts
  • #257553

    Masum Khan
    Participant

    I am scaling my store to 10,000+ products on a high-performance server, but the current ALD data architecture is unsustainable.

    1. Data Bloat: Individual products (e.g., ID 463) are storing 5.6 MB of raw JSON in wp_ald_postmeta under the _vi_wad_reviews key. This happens even with “Import Reviews” disabled.

    2. Performance Impact: Query Monitor shows massive duplicate queries for these large JSON blobs. The plugin is requesting these 5MB+ files multiple times per page load, causing 2-3 second delays and triggering CloudLinux Resource Limits.

    3. The Request: I need a clear technical manifest of which meta keys in wp_ald_postmeta are strictly necessary for Price/Stock syncing.

    Specifically:
    -Can I safely delete _vi_wad_reviews without breaking the core sync?
    -Is there a way to prevent the plugin from ever requesting or saving the “Review” and “Full Shipping” data at the API level?
    -Can you implement static caching for these queries to stop the duplicate DB requests?

    I am ready to scale, but I cannot do so until the “Ghost” data is removed at the root.

You must be logged in to see replies to this topic. Click here to login or register