jjxtra

More evidence woocommerce is the culprit–from new relic. Again, my db is tiny, I have maybe 1k customers, 2k orders and 15 products.

Here’s a video showing the horrifying number of queries. Seriously, why is every order id in existance being queried individually? For an orders page, it should be ONE query. Similar insanity happens on the products page and individual product pages, though it’s a little less terrible (only a little).

• This reply was modified 5 months, 2 weeks ago by jjxtra.

Deactivated incompatible plugins and enabled HPOS. Load times are improved by ~10%. The root of the issue here is the thousands of queries woocommerce makes just to load a single page. Do you have an ETA on when you’ll be able to fix your code to not make such a horrendous amount of queries?

• This reply was modified 5 months, 2 weeks ago by jjxtra.

And the HPOS isn’t compatible with several plugins, so looks like I’m stuck with poor performance due to the inefficient number of queries being made in the woocommerce code.

Tried the mysql index plugin. Load times are still dreadful, still over 1000 queries made by woocommerce.

How do I switch to HPOS? (never mind, found it)

• This reply was modified 5 months, 2 weeks ago by jjxtra.

95% of the time is spent pegging the CPU at 100%. So the front end has little to do with this. I will check out the mysql indexing plugin you suggested.

Video of super slow admin orders page loading: https://youtu.be/fiA8Ivd_JOQ

I have ~1500 customer orders, and 15 products.

Here’s a product link you can try where I’ve bypassed the cache: https://ipban.com/products/ipban-pro-datacenter-annual-subscription/?t=123123123123545

• This reply was modified 5 months, 2 weeks ago by jjxtra.
• This reply was modified 5 months, 2 weeks ago by jjxtra.

Please read my entire message. You must change the t= query string value to something new to bust the cache.

Of note is the tiny size of my db, only 70mb with 30mb of indexes.

WordPress Environment

WordPress address (URL): https://ipban.com
Site address (URL): https://ipban.com
WC Version: 8.9.2
REST API Version: ? 8.9.2
Action Scheduler Version: ? 3.7.4
Log Directory Writable: ?
WP Version: 6.5.4
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: – Server Environment

Server Info: nginx/1.18.0
PHP Version: 8.3.6
PHP Post Max Size: 50 MB
PHP Time Limit: 180
PHP Max Input Vars: 3000
cURL Version: 7.81.0
OpenSSL/3.0.2

SUHOSIN Installed: –
MySQL Version: 8.0.36-0ubuntu0.22.04.1
Max Upload Size: 50 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ? Database

WC Database Version: 8.9.2
WC Database Prefix: wp_
Total Database Size: 96.14MB
Database Data Size: 60.38MB
Database Index Size: 35.76MB
wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.17MB + Index: 0.34MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.38MB + Index: 0.13MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 2.02MB + Index: 0.84MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.44MB + Index: 0.34MB + Engine InnoDB
wp_ahm_assets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_download_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ahm_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_audit_log: Data: 4.02MB + Index: 0.16MB + Engine InnoDB
wp_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_logged_in_users: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_aiowps_login_lockdown: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_aiowps_message_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 3.52MB + Index: 3.36MB + Engine InnoDB
wp_dlm_order: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_dlm_order_customer: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_order_item: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_order_transaction: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_dlm_session: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_download_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_carts: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_customer_orders: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wp_followup_customers: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_followup_email_logs: Data: 0.16MB + Index: 0.11MB + Engine InnoDB
wp_followup_email_orders: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wp_followup_email_tracking: Data: 0.09MB + Index: 0.11MB + Engine InnoDB
wp_followup_followup_history: Data: 1.52MB + Index: 0.14MB + Engine InnoDB
wp_followup_order_categories: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_followup_order_items: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_layerslider: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wp_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_layerslider_revisions: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wp_newsletter_emails: Data: 0.28MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_sent: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_newsletter_stats: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_newsletter_user_logs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_newsletter_user_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 8.23MB + Index: 0.22MB + Engine InnoDB
wp_postmeta: Data: 14.55MB + Index: 16.02MB + Engine InnoDB
wp_posts: Data: 5.52MB + Index: 0.86MB + Engine InnoDB
wp_redirection_404: Data: 0.16MB + Index: 0.05MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_simple_history: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wp_simple_history_contexts: Data: 2.02MB + Index: 0.48MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_usermeta: Data: 3.52MB + Index: 4.03MB + Engine InnoDB
wp_users: Data: 0.19MB + Index: 0.16MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_comments_subscription: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.14MB + Index: 0.11MB + Engine InnoDB
wp_wc_download_log: Data: 0.17MB + Index: 0.14MB + Engine InnoDB
wp_wc_feedback_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_follow_users: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.33MB + Index: 0.34MB + Engine InnoDB
wp_wc_order_stats: Data: 0.45MB + Index: 0.27MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_phrases: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_users_rated: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_users_voted: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wcs_payment_retries: Data: 0.22MB + Index: 0.02MB + Engine InnoDB
wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_emails_log: Data: 1.02MB + Index: 0.03MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts

attachment: 98
avada_faq: 22
custom_css: 1
dlm_download: 3
dlm_download_version: 3
elementor_library: 3
follow_up_email: 4
fusion_element: 6
fusion_icons: 1
fusion_tb_layout: 2
fusion_tb_section: 8
nav_menu_item: 13
oembed_cache: 12
page: 41
post: 52
product: 10
shop_coupon: 12
shop_order: 2790
shop_order_refund: 38
shop_subscription: 1154
wp_global_styles: 1
wp_navigation: 1
wpdiscuz_form: 1
wpdmpro: 1
wpforms: 1
xlwcty_thankyou: 1 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (43)

Smart Custom 404 error page [404page]: by Peter Raschendorfer – 11.4.6
LayerSlider: by Kreatura Media – 7.11.1
Ajax Cart AutoUpdate for WooCommerce: by taisho – 1.5.5
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.2
All In One WP Security: by All In One WP Security & Firewall Team – 5.3.0
Custom Stuff: by –
Disable XML-RPC-API: by Neatma – 2.1.5
Free Downloads WooCommerce: by WP Enhanced – 3.5.8.3
Elementor Pro: by Elementor.com – 3.21.3
Elementor: by Elementor.com – 3.21.8
Avada Builder: by ThemeFusion – 3.11.9
Avada Core: by ThemeFusion – 5.11.9
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.35

Head, Footer and Post Injections: by Stefano Lissa – 3.2.8
LoginPress: by LoginPress – 3.0.8
Min and Max Quantity for WooCommerce: by BeRocket – 1.3.4.1
Newsletter: by Stefano Lissa & The Newsletter Team – 8.3.8
PHP Native Password Hash: by Ayesh Karunaratne – 3.0
Rearrange Woocommerce Products: by Aslam Doctor – 4.3.0
reCaptcha for WooCommerce: by I Thirteen Web Solution – 2.37
Redirection: by John Godley – 5.4.2
Simple Custom CSS: by John Regan – 4.0.6
Simple History: by P?r Thernstr?m – 4.15.1
SMNTCS Disable REST API User Endpoints: by Niels Lange – 2.2
The Paste: by J?rn Lund – 2.1.1
Two Factor: by Plugin Contributors – 0.9.1
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.16.47

Coupons & Add to Cart by URL Links for WooCommerce: by WPFactory – 1.7.1
Version Control for jQuery: by Leander Iversen – 3.9
WooCommerce Custom Add To Cart Button: by Kestrel – 1.2.5
Discount Rules Core: by Flycart – 2.6.3
WooCommerce Stripe Gateway: by WooCommerce – 8.3.1
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.3
Woocommerce Side Cart Premium: by XootiX – 3.0
Woo Subscriptions: by WooCommerce – 6.2.0 (update to version 6.3.2 is available)
WooCommerce: by Automattic – 8.9.2
Yoast SEO: by Team Yoast – 22.8
WP Crontrol: by John Blackbourn – 1.16.3
WP Fastest Cache Premium: by Emre Vona – 1.7.0
WP Fastest Cache: by Emre Vona – 1.2.7
WP Mail SMTP Pro: by WP Mail SMTP – 4.0.2
wpDiscuz: by gVectors Team – 7.6.19
WPForms Lite: by WPForms – 1.8.8.3 Inactive Plugins (2)

Query Monitor: by John Blackbourn – 3.16.3
WP Mail SMTP: by WP Mail SMTP – 4.0.1 Dropin Plugins ()

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in) Must Use Plugins (1)

aios-firewall-loader.php: by – Settings

API Enabled: –
Force SSL: –
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
subscription (subscription)
variable (variable)
variable subscription (variable-subscription)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ?
Enforce Approved Product Download Directories: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – Logging

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 5 MB WC Pages

Shop base: #570 - /products/
Cart: #8 - /cart/
Checkout: #9 - /checkout/
My account: #10 - /my-account/
Terms and conditions: #11 - /terms-and-conditions/ Theme

Name: Avada
Version: 7.11.9
Author URL: https://themeforest.net/user/ThemeFusion
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
WooCommerce Support: ? Templates

Overrides: Avada/woocommerce/cart/cart.php
Avada/woocommerce/checkout/form-pay.php
Avada/woocommerce/checkout/review-order.php
Avada/woocommerce/single-product/short-description.php
Avada/woocommerce/single-product/tabs/additional-information.php
Avada/woocommerce/single-product/tabs/description.php Subscriptions

WCS_DEBUG: ? No
Subscriptions Mode: ? Live
Subscriptions Live URL: https://ipban.com
Subscriptions-core Library Version: 7.0.0
Subscription Statuses: wc-active: 689
wc-pending-cancel: 15
wc-on-hold: 180
wc-cancelled: 270

WooCommerce Account Connected: ? Yes
Active Product Key: ? Yes
Custom Retry Rules: ? No
Custom Retry Rule Class: ? No
Custom Raw Retry Rule: ? No
Custom Retry Rule: ? No
Retries Migration Status: ? Completed
Report Cache Enabled: ? Yes
Cache Update Failures: ? 0 failure Store Setup

Country / State: United States (US) — Utah Subscriptions by Payment Gateway

Stripe: wc-cancelled: 136
wc-active: 402
wc-on-hold: 113
wc-pending-cancel: 8

PayPal Standard: wc-active: 287
wc-cancelled: 134
wc-on-hold: 67
wc-pending-cancel: 7 Payment Gateway Support

PayPal Standard: subscription_payment_method_change_customer
subscription_payment_method_change_admin
subscription_amount_changes
subscription_date_changes
multiple_subscriptions
subscription_payment_method_delayed_change
subscriptions
subscription_cancellation
subscription_suspension
subscription_reactivation
products
refunds

PayPal Reference Transactions Enabled: ? Yes
Stripe: products
refunds
tokenization
add_payment_method
subscriptions
subscription_cancellation
subscription_suspension
subscription_reactivation
subscription_amount_changes
subscription_date_changes
subscription_payment_method_change
subscription_payment_method_change_customer
subscription_payment_method_change_admin
multiple_subscriptions Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
product-pre-publish-modal
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
settings
async-product-editor-category-field
launch-your-store

Daily Cron: ? Next scheduled: 2024-06-10 20:33:47 -06:00
Options: ?
Notes: 146
Onboarding: completed Action Scheduler

Canceled: 1
Oldest: 2024-06-05 22:24:05 -0600
Newest: 2024-06-05 22:24:05 -0600

Complete: 1,549
Oldest: 2024-05-09 18:49:04 -0600
Newest: 2024-06-09 12:58:05 -0600

Failed: 50
Oldest: 2023-03-28 07:55:17 -0600
Newest: 2024-05-28 09:04:23 -0600

Pending: 715
Oldest: 2024-06-09 17:13:44 -0600
Newest: 2029-06-05 09:30:34 -0600 Status report information

Generated at: 2024-06-09 16:25:41 -06:00

Exact same problem here. Maybe it’s my other plugins I thought… so as a test I disabled all official woocommerce plugins. Boom suddenly performance is 5x faster. Re-enable the plugins and it’s slow as molasses in January again.

• This reply was modified 2 years, 4 months ago by jjxtra.
• This reply was modified 2 years, 4 months ago by jjxtra.

I did check that box prior still no luck. I am moving in a different direction here, thanks for responding though.

My product definitely has downloads. I can checkout for free and then go to my downloads and download a zip file.

I am using elementor on my product page, but not my products archive page. The download button does not show on either.

Really hoping for a configuration option of number of retries and exponential back-off parameters. Being able to do this globally for starters would be great, but eventually an override per web-hook would be nice too.