{"action":"created","issue":{"url":"https://api.github.com/repos/woocommerce/woocommerce/issues/21717","repository_url":"https://api.github.com/repos/woocommerce/woocommerce","labels_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/21717/labels{/name}","comments_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/21717/comments","events_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/21717/events","html_url":"https://github.com/woocommerce/woocommerce/issues/21717","id":374677461,"node_id":"MDU6SXNzdWUzNzQ2Nzc0NjE=","number":21717,"title":"\"Orders\" page in WooCommerce (edit.php?post_type=shop_order) very slow","user":{"login":"thistehneisen","id":6432992,"node_id":"MDQ6VXNlcjY0MzI5OTI=","avatar_url":"https://avatars1.githubusercontent.com/u/6432992?v=4","gravatar_id":"","url":"https://api.github.com/users/thistehneisen","html_url":"https://github.com/thistehneisen","followers_url":"https://api.github.com/users/thistehneisen/followers","following_url":"https://api.github.com/users/thistehneisen/following{/other_user}","gists_url":"https://api.github.com/users/thistehneisen/gists{/gist_id}","starred_url":"https://api.github.com/users/thistehneisen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/thistehneisen/subscriptions","organizations_url":"https://api.github.com/users/thistehneisen/orgs","repos_url":"https://api.github.com/users/thistehneisen/repos","events_url":"https://api.github.com/users/thistehneisen/events{/privacy}","received_events_url":"https://api.github.com/users/thistehneisen/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-27T19:00:13Z","updated_at":"2018-10-30T17:35:51Z","closed_at":null,"author_association":"NONE","body":"**Describe the bug**\r\nCurrently I have tried pretty much everything on my mind, including:\r\n\r\n1. Optimizing, repairing all of the database tables\r\n2. Disabling all of the plugins, except WooCommerce\r\n3. Due to only thing seen in Network debugger was admin-ajax.php request via XHR - disabled Heartbeat.\r\n4. Clearing all WooCommerce caches, including sessions\r\n5. Switching between Apache FastCGI, FPM and nginx - pretty much the same result.\r\n6. Removing existing plugins/woocommerce/ and git cloning a fresh one into it. (By the way, if the version is 3.5.0-rc1, WordPress asks to update to 3.5.0, seems not right)\r\n\r\nStill, the load time is six minutes to partially load the orders page (not all orders are being displayed, neither the pagination on bottom is loaded).\r\nScreenshot of the Network: https://www.nils.digital/orders.png\r\n\r\nCurrently the PHP is set to 30G memory_limit, so it has to be a strong memory leak.\r\n\r\nPlease, inform me of any further details required to resolve this issue.\r\n\r\nRequest to the page:\r\n```\r\nRequest URL: https://*.com/wp-admin/edit.php?post_type=shop_order\r\nReferrer Policy: strict-origin-when-cross-origin\r\nProvisional headers are shown\r\nReferer: https://*.com/wp-admin/options-general.php?page=heartbeat_control_settings\r\nUpgrade-Insecure-Requests: 1\r\nUser-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36\r\nX-DevTools-Emulate-Network-Conditions-Client-Id: 0F9469D317A73A557D0E787D1249A9FF\r\npost_type: shop_order\r\n```\r\n\r\n**Isolating the problem (mark completed items with an [x]):**\r\n- [x] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.\r\n- [x] This bug happens with a default WordPress theme active, or [Storefront](https://woocommerce.com/storefront/).\r\n- [x] I can reproduce this bug consistently using the steps above.\r\n\r\n**WordPress Environment**\r\n<details>\r\n```\r\nWC Version: 3.5.0\r\nLog Directory Writable: ✔\r\nWP Version: 4.9.8\r\nWP Multisite: –\r\nWP Memory Limit: 30 GB\r\nWP Debug Mode: ✔\r\nWP Cron: –\r\nLanguage: en_US\r\nExternal object cache: –\r\n\r\n### Server Environment ###\r\n\r\nServer Info: nginx/1.13.8\r\nPHP Version: 7.2.11\r\nPHP Post Max Size: 1 GB\r\nPHP Time Limit: 360\r\nPHP Max Input Vars: 1000\r\ncURL Version: 7.58.0\r\nOpenSSL/1.1.0h\r\n\r\nSUHOSIN Installed: –\r\nMySQL Version: 5.7.24-0ubuntu0.18.04.1\r\nMax Upload Size: 1 GB\r\nDefault Timezone is UTC: ✔\r\nfsockopen/cURL: ✔\r\nSoapClient: ✔\r\nDOMDocument: ✔\r\nGZip: ✔\r\nMultibyte String: ✔\r\nRemote Post: ✔\r\nRemote Get: ✔\r\n\r\n### Database ###\r\n\r\nWC Database Version: 3.5.0\r\nWC Database Prefix: 1aC6THc9do_\r\nMaxMind GeoIP Database: ✔\r\nTotal Database Size: 8.46MB\r\nDatabase Data Size: 7.33MB\r\nDatabase Index Size: 1.13MB\r\n1aC6THc9do_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB\r\n1aC6THc9do_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_order_items: Data: 0.02MB + Index: 0.01MB\r\n1aC6THc9do_woocommerce_order_itemmeta: Data: 0.26MB + Index: 0.09MB\r\n1aC6THc9do_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_woocommerce_log: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_commentmeta: Data: 0.05MB + Index: 0.02MB\r\n1aC6THc9do_comments: Data: 0.19MB + Index: 0.09MB\r\n1aC6THc9do_failed_jobs: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_links: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_mailchimp_carts: Data: 0.09MB + Index: 0.00MB\r\n1aC6THc9do_options: Data: 1.62MB + Index: 0.14MB\r\n1aC6THc9do_postmeta: Data: 3.43MB + Index: 0.58MB\r\n1aC6THc9do_posts: Data: 0.84MB + Index: 0.10MB\r\n1aC6THc9do_pps_countries: Data: 0.01MB + Index: 0.00MB\r\n1aC6THc9do_pps_modules: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_modules_type: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_popup: Data: 0.60MB + Index: 0.00MB\r\n1aC6THc9do_pps_popup_show_categories: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_popup_show_pages: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_statistics: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_subscribers: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_pps_usage_stat: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_queue: Data: 0.02MB + Index: 0.00MB\r\n1aC6THc9do_revslider_css: Data: 0.09MB + Index: 0.00MB\r\n1aC6THc9do_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_revslider_navigations: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_revslider_sliders: Data: 0.01MB + Index: 0.00MB\r\n1aC6THc9do_revslider_slides: Data: 0.02MB + Index: 0.00MB\r\n1aC6THc9do_revslider_static_slides: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_smush_dir_images: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_termmeta: Data: 0.01MB + Index: 0.02MB\r\n1aC6THc9do_terms: Data: 0.01MB + Index: 0.02MB\r\n1aC6THc9do_term_relationships: Data: 0.01MB + Index: 0.01MB\r\n1aC6THc9do_term_taxonomy: Data: 0.01MB + Index: 0.01MB\r\n1aC6THc9do_usermeta: Data: 0.03MB + Index: 0.02MB\r\n1aC6THc9do_users: Data: 0.00MB + Index: 0.01MB\r\n1aC6THc9do_wc_download_log: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_wc_webhooks: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_wooup_offers: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_wooup_stats: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_wooup_view_stats: Data: 0.00MB + Index: 0.00MB\r\n1aC6THc9do_wsf: Data: 0.00MB + Index: 0.00MB\r\n\r\n### Post Type Counts ###\r\n\r\nattachment: 393\r\ncustom_css: 1\r\ncustomize_changeset: 1\r\njetpack_migration: 2\r\njp_img_sitemap: 1\r\njp_sitemap: 1\r\njp_sitemap_master: 1\r\nnav_menu_item: 26\r\noembed_cache: 1\r\npage: 19\r\npost: 3\r\nproduct: 34\r\nproduct_variation: 53\r\nrevision: 66\r\nscheduled-action: 6\r\nshop_coupon: 7\r\nshop_order: 175\r\nshop_order_refund: 3\r\nwoo_discount: 1\r\nwpautoterms_page: 1\r\nwpcf7_contact_form: 1\r\nywar_reviews: 19\r\n\r\n### Security ###\r\n\r\nSecure connection (HTTPS): ✔\r\nHide errors from visitors: ✔\r\n\r\n### Active Plugins (19) ###\r\n\r\nAfterShip - WooCommerce Tracking: by AfterShip – 1.9.2 – Not tested with the active version of WooCommerce\r\nARG Multistep Checkout for WooCommerce: by ARG Themes – 3.6 – Not tested with the active version of WooCommerce\r\nBeeketing For WooCommerce: by Beeketing – 3.7.14 – Not tested with the active version of WooCommerce\r\nCardinity Payment Gateway: by Cardinity – 1.3.0 – Not tested with the active version of WooCommerce\r\nCheckout Countdown for WooCommerce: by Extra Woo\r\nMorgan Hvidt – 2.2 – Not tested with the active version of WooCommerce\r\n\r\nContact Form 7: by Takayuki Miyoshi – 5.0.4\r\nDivi Booster: by Dan Mossop – 2.7.9\r\nPayPal Express Checkout for WooCommerce: by wpgateways – 3.0.3 – Not tested with the active version of WooCommerce\r\nGutenberg: by Gutenberg Team – 4.1.1\r\nHeartbeat Control: by Jeff Matson – 1.2.5\r\nPixelYourSite: by PixelYourSite – 5.3.2 – Not tested with the active version of WooCommerce\r\nSlider Revolution: by ThemePunch – 5.4.5\r\nWoo Discount Rules: by Flycart Technologies LLP – 1.6.18 – Not tested with the active version of WooCommerce\r\nAdvanced Order Export For WooCommerce: by AlgolPlus – 2.0.0\r\nWooCommerce Photo Reviews: by VillaTheme – 1.0.9.9 – Not tested with the active version of WooCommerce\r\nWooCommerce Currency Switcher: by realmag777 – 2.2.5.1 – Not tested with the active version of WooCommerce\r\nWooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.2.3\r\nWooCommerce Shipping Tracking: by Lagudi Domenico – 15.3 – Not tested with the active version of WooCommerce\r\nWooCommerce: by Automattic – 3.5.0\r\n\r\n### Settings ###\r\n\r\nAPI Enabled: –\r\nForce SSL: –\r\nCurrency: USD ($)\r\nCurrency Position: left\r\nThousand Separator: ,\r\nDecimal Separator: .\r\nNumber of Decimals: 2\r\nTaxonomies: Product Types: external (external)\r\ngrouped (grouped)\r\nsimple (simple)\r\nvariable (variable)\r\n\r\nTaxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)\r\nexclude-from-search (exclude-from-search)\r\nfeatured (featured)\r\noutofstock (outofstock)\r\nrated-1 (rated-1)\r\nrated-2 (rated-2)\r\nrated-3 (rated-3)\r\nrated-4 (rated-4)\r\nrated-5 (rated-5)\r\n\r\n\r\n### WC Pages ###\r\n\r\nShop base: #7 - /shop/\r\nCart: #8 - /cart/\r\nCheckout: #9 - /checkout/\r\nMy account: #10 - /my-account/\r\nTerms and conditions: #6916 - /terms-and-conditions/\r\n\r\n### Theme ###\r\n\r\nName: Divi Child\r\nVersion: 1.0\r\nAuthor URL: \r\nChild Theme: ✔\r\nParent Theme Name: Divi\r\nParent Theme Version: 3.15\r\nParent Theme Author URL: http://www.elegantthemes.com\r\nWooCommerce Support: ✔\r\n\r\n### Templates ###\r\n\r\nOverrides: Divi-child/woocommerce/cart/cart-shipping.php version 3.2.0 is out of date. The core version is 3.5.0\r\nDivi-child/woocommerce/cart/cart-totals.php\r\nDivi-child/woocommerce/cart/cart.php version 3.4.0 is out of date. The core version is 3.5.0\r\nDivi-child/woocommerce/cart/mini-cart.php version 3.3.0 is out of date. The core version is 3.5.0\r\nDivi-child/woocommerce/cart/proceed-to-checkout-button.php\r\nDivi-child/woocommerce/checkout/form-billing.php\r\nDivi-child/woocommerce/checkout/form-checkout.php version 2.3.0 is out of date. The core version is 3.5.0\r\nDivi-child/woocommerce/checkout/review-order.php\r\nDivi-child/woocommerce/myaccount/form-login.php version 3.4.0 is out of date. The core version is 3.5.0\r\nDivi-child/woocommerce/single-product/add-to-cart/grouped.php\r\nDivi-child/woocommerce/single-product/price.php\r\n\r\nOutdated Templates: ❌\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\tLearn how to update\r\n```\r\n</details>\r\n"},"comment":{"url":"https://api.github.com/repos/woocommerce/woocommerce/issues/comments/434398621","html_url":"https://github.com/woocommerce/woocommerce/issues/21717#issuecomment-434398621","issue_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/21717","id":434398621,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDM5ODYyMQ==","user":{"login":"rodrigoprimo","id":77215,"node_id":"MDQ6VXNlcjc3MjE1","avatar_url":"https://avatars2.githubusercontent.com/u/77215?v=4","gravatar_id":"","url":"https://api.github.com/users/rodrigoprimo","html_url":"https://github.com/rodrigoprimo","followers_url":"https://api.github.com/users/rodrigoprimo/followers","following_url":"https://api.github.com/users/rodrigoprimo/following{/other_user}","gists_url":"https://api.github.com/users/rodrigoprimo/gists{/gist_id}","starred_url":"https://api.github.com/users/rodrigoprimo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rodrigoprimo/subscriptions","organizations_url":"https://api.github.com/users/rodrigoprimo/orgs","repos_url":"https://api.github.com/users/rodrigoprimo/repos","events_url":"https://api.github.com/users/rodrigoprimo/events{/privacy}","received_events_url":"https://api.github.com/users/rodrigoprimo/received_events","type":"User","site_admin":false},"created_at":"2018-10-30T17:35:51Z","updated_at":"2018-10-30T17:35:51Z","author_association":"CONTRIBUTOR","body":"6 minutes to load the orders pages, especially for a store with a relatively small number of orders is not normal and not expected as well. It is unlikely that WooCommerce core alone is causing this. Would you be able to install [query-monitor](https://wordpress.org/plugins/query-monitor/) or any other tool that would tell you where the server is spending time? I'd be curious to know the page generation time, peak memory usage and database query time. If it is spending a significant amount of time running queries, which are the slowest queries?"}}
{"actor":{"display_login":"rodrigoprimo"}}