Order creation is extremely slow (5-20 minutes)

Hi, I have a B2B site that needs to manage large orders. It is for a clothing distributor, so with size/color variations.
I can have an order of 50-60 products that, with variations, can generate 3.000-6.000 “pieces” in the cart (I mean, if product A red size S has 5 items and blu size S has 3 items, I count 8 “pieces” in total).
Each product can have from 4-5 (single color, multiple sizes) to 50-100 variations (multiple colors for each size).
There is no payment gateway as it is for reseller that will pay later.
as I click on “place order” button, the circle starts rotating and it remains that way for a time that may vary from 4-5 minutes to even 20 minutes.
The confirmation email arrive a couple of minutes before circle finish to rotate and lead to the confirmation page.

I already tried to:
– disable all the plugins except Woocommerce
– run it with twenty-twentytwo theme
– use add_filter( ‘woocommerce_defer_transactional_emails’,’__return_true’ );
– disable ajax on woocommerce > settings > products > general
– change server, it was on a good one, now is on a high performance server but the problem persists.

Any idea on why it happens and how to solve it?
Thanks

here it is the woocommerce > status code

WordPress Environment

WordPress address (URL): https://staging.mysite.it
Site address (URL): https://staging.mysite.it
WC Version: 7.3.0
REST API Version: ?</img> 7.3.0
WC Blocks Version: ?</img> 9.1.5
Action Scheduler Version: ?</img> 3.4.0
Log Directory Writable: ?</img>
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ?</img>
Language: it_IT
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 8.1.13
PHP Post Max Size: 150 MB
PHP Time Limit: 180
PHP Max Input Vars: 35000
cURL Version: 7.86.0
OpenSSL/1.1.1s

SUHOSIN Installed: –
MySQL Version: 5.7.38-log
Max Upload Size: 150 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.3.0
WC Database Prefix: wpck_
Dimensione totale database: 1207.98MB
Dimensione dati database: 721.42MB
Dimensione indice database: 486.56MB
wpck_woocommerce_sessions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_woocommerce_api_keys: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_woocommerce_attribute_taxonomies: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_woocommerce_downloadable_product_permissions: Dati: 0.02MB + indice: 0.06MB + motore InnoDB
wpck_woocommerce_order_items: Dati: 13.52MB + indice: 3.52MB + motore InnoDB
wpck_woocommerce_order_itemmeta: Dati: 122.64MB + indice: 117.33MB + motore InnoDB
wpck_woocommerce_tax_rates: Dati: 0.02MB + indice: 0.06MB + motore InnoDB
wpck_woocommerce_tax_rate_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_woocommerce_payment_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_woocommerce_payment_tokenmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_woocommerce_log: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_actionscheduler_actions: Dati: 27.06MB + indice: 28.09MB + motore InnoDB
wpck_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_actionscheduler_logs: Dati: 19.55MB + indice: 16.03MB + motore InnoDB
wpck_atum_order_itemmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_atum_order_items: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_atum_product_data: Dati: 5.52MB + indice: 4.55MB + motore InnoDB
wpck_berocket_termmeta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_braapf_product_stock_status_parent: Dati: 2.52MB + indice: 1.52MB + motore InnoDB
wpck_braapf_product_variation_attributes: Dati: 5.52MB + indice: 12.55MB + motore InnoDB
wpck_braapf_term_taxonomy_hierarchical: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_braapf_variable_attributes: Dati: 0.11MB + indice: 0.19MB + motore InnoDB
wpck_check_email_log: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_cli_cookie_scan: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_cli_cookie_scan_categories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_cli_cookie_scan_cookies: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_cli_cookie_scan_url: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_cli_scripts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_commentmeta: Dati: 0.09MB + indice: 0.03MB + motore InnoDB
wpck_comments: Dati: 24.52MB + indice: 0.81MB + motore InnoDB
wpck_duplicator_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_duplicator_pro_entities: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_duplicator_pro_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_evf_entries: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_evf_entrymeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_evf_sessions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_e_events: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_e_submissions: Dati: 0.06MB + indice: 0.27MB + motore InnoDB
wpck_e_submissions_actions_log: Dati: 0.02MB + indice: 0.11MB + motore InnoDB
wpck_e_submissions_values: Dati: 0.11MB + indice: 0.03MB + motore InnoDB
wpck_fbv: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_fbv_attachment_folder: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_links: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_ms_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_options: Dati: 21.08MB + indice: 0.39MB + motore InnoDB
wpck_pmxe_exports: Dati: 0.11MB + indice: 0.00MB + motore InnoDB
wpck_pmxe_google_cats: Dati: 0.39MB + indice: 0.00MB + motore InnoDB
wpck_pmxe_posts: Dati: 1.52MB + indice: 0.00MB + motore InnoDB
wpck_pmxe_templates: Dati: 0.09MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_files: Dati: 0.11MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_hash: Dati: 4.52MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_history: Dati: 0.05MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_images: Dati: 0.13MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_imports: Dati: 7.52MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_posts: Dati: 6.52MB + indice: 0.00MB + motore InnoDB
wpck_pmxi_templates: Dati: 1.52MB + indice: 0.00MB + motore InnoDB
wpck_postmeta: Dati: 203.66MB + indice: 127.41MB + motore InnoDB
wpck_posts: Dati: 42.55MB + indice: 18.13MB + motore InnoDB
wpck_prflxtrflds_fields_meta: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_redirection_404: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_redirection_groups: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_redirection_items: Dati: 0.02MB + indice: 0.09MB + motore InnoDB
wpck_redirection_logs: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_say_what_strings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_simple_history: Dati: 22.56MB + indice: 11.03MB + motore InnoDB
wpck_simple_history_contexts: Dati: 116.66MB + indice: 83.22MB + motore InnoDB
wpck_sm_advanced_search_temp: Dati: 0.23MB + indice: 0.09MB + motore InnoDB
wpck_sm_views: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_snippets: Dati: 0.20MB + indice: 0.03MB + motore InnoDB
wpck_termmeta: Dati: 0.09MB + indice: 0.11MB + motore InnoDB
wpck_terms: Dati: 0.09MB + indice: 0.09MB + motore InnoDB
wpck_term_relationships: Dati: 2.52MB + indice: 2.52MB + motore InnoDB
wpck_term_taxonomy: Dati: 0.09MB + indice: 0.11MB + motore InnoDB
wpck_usermeta: Dati: 3.52MB + indice: 4.03MB + motore InnoDB
wpck_users: Dati: 0.11MB + indice: 0.14MB + motore InnoDB
wpck_wa_confirmationlinks: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wa_log: Dati: 0.13MB + indice: 0.00MB + motore InnoDB
wpck_wa_queue: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wcpdf_invoice_number: Dati: 0.09MB + indice: 0.00MB + motore InnoDB
wpck_wc_admin_notes: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wc_admin_note_actions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wc_customer_lookup: Dati: 0.09MB + indice: 0.06MB + motore InnoDB
wpck_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_wc_order_coupon_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_wc_order_product_lookup: Dati: 14.55MB + indice: 17.06MB + motore InnoDB
wpck_wc_order_stats: Dati: 0.23MB + indice: 0.22MB + motore InnoDB
wpck_wc_order_tax_lookup: Dati: 0.14MB + indice: 0.14MB + motore InnoDB
wpck_wc_product_attributes_lookup: Dati: 5.52MB + indice: 5.52MB + motore InnoDB
wpck_wc_product_download_directories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wc_product_meta_lookup: Dati: 5.52MB + indice: 11.09MB + motore InnoDB
wpck_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wdp_orders: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_wdp_order_items: Dati: 0.02MB + indice: 0.06MB + motore InnoDB
wpck_wdp_rules: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_wfblockediplog: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wfblocks7: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_wfconfig: Dati: 0.52MB + indice: 0.00MB + motore InnoDB
wpck_wfcrawlers: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wffilechanges: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wffilemods: Dati: 6.52MB + indice: 0.00MB + motore InnoDB
wpck_wfhits: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_wfhoover: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wfissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB
wpck_wfknownfilelist: Dati: 7.52MB + indice: 0.00MB + motore InnoDB
wpck_wflivetraffichuman: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wflocs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wflogins: Dati: 0.44MB + indice: 0.16MB + motore InnoDB
wpck_wfls_2fa_secrets: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wfls_settings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wfnotifications: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wfpendingissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB
wpck_wfreversecache: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wfsnipcache: Dati: 0.02MB + indice: 0.05MB + motore InnoDB
wpck_wfstatus: Dati: 0.16MB + indice: 0.11MB + motore InnoDB
wpck_wftrafficrates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wobef_history: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_wobef_history_items: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_wpfm_backup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wpie_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wpmembers_user_search_keys: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wpmm_subscribers: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wt_iew_action_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wt_iew_cron: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wt_iew_ftp: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_wt_iew_mapping_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB
wpck_yoast_indexable: Dati: 18.55MB + indice: 13.56MB + motore InnoDB
wpck_yoast_indexable_hierarchy: Dati: 2.52MB + indice: 4.55MB + motore InnoDB
wpck_yoast_migrations: Dati: 0.02MB + indice: 0.02MB + motore InnoDB
wpck_yoast_primary_term: Dati: 0.02MB + indice: 0.03MB + motore InnoDB
wpck_yoast_seo_links: Dati: 0.14MB + indice: 0.09MB + motore InnoDB

Post Type Counts

attachment: 1505
atum_inventory_log: 1
automation-workflow: 1
awdp_pt_products: 5
awdp_pt_rules: 5
bnfw_notification: 1
br_product_filter: 5
custom_css: 3
elementor_library: 6
elementskit_template: 2
everest_form: 2
nav_menu_item: 104
page: 45
portfolio: 8
post: 1
postman_sent_mail: 250
product: 1084
product_variation: 43146
revision: 508
shop_coupon: 1
shop_order: 1843
shop_order_refund: 1
wcb2b_group: 16
wcssc-cart: 434
wp_global_styles: 2
wpcf7_contact_form: 1
wpsl_stores: 201
wpt_product_table: 1

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (1)

WooCommerce: by Automattic – 7.3.0

Inactive Plugins (67)

Advanced AJAX Product Filters for WooCommerce: by BeRocket – 1.6.3.4
Advanced Order Export For WooCommerce: by AlgolPlus – 3.3.3
Advanced Order Export For WooCommerce (Pro): by AlgolPlus – 3.2.2
All-in-One WP Migration With Import: by ServMask – 6.77
Allow Webp Image: by Top Infosoft – 1.0.1
Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.21.90
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.9.26.2
Bulk remove posts from category: by MasterNs – 3.3
Category Discount Woocommerce: by QuanticEdge – 4.7
Check & Log Email: by WPChill – 1.0.6
Child Theme Configurator: by Lilaea Media – 2.6.0
Code Snippets: by Code Snippets Pro – 3.2.2
Contact Form 7: by Takayuki Miyoshi – 5.7.3
CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.8
Database Collation Fix: by Dave Jesch – 1.2.7
Disable Real MIME Check: by Sergey Biryukov – 1.0
Duplicator: by Snap Creek – 1.5.2
DynamicConditions: by RTO GmbH – 1.6.0
Elementor: by Elementor.com – 3.7.2
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.13

Elementor Pro: by Elementor.com – 3.7.3
ELEX Dynamic Pricing and Discounts for WooCommerce Basic Version: by ELEXtensions – 1.2.9
Export All URLs: by Atlas Gondal – 4.4
FileBird Lite: by Ninja Team – 5.1.4
Flexible Checkout Fields: by WP Desk – 3.5.4
Flexible Checkout Fields PRO: by WP Desk – 3.5.1
Health Check & Troubleshooting: by The www.ads-software.com community – 1.5.1
Import and export users and customers: by codection – 1.21.4
iThemeland WooCommerce Bulk Orders Editing Lite: by iThemelandco – 2.0.0
LightStart - Maintenance Mode, Coming Soon and Landing Page Builder: by Themeisle – 2.6.2
Nav Menu Collapse: by Robert Noakes – 2.1.2
Ocean Extra: by OceanWP – 2.1.1
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.3.1
Post SMTP: by Post SMTP – 2.3.2
Product Prices by User Roles for WooCommerce: by Tyche Softwares – 1.6.0
Product SKU Generator for WooCommerce: by SkyVerge – 2.4.8
Redirection: by John Godley – 5.3.9
Save and Share Cart for WooCommerce: by Ankit Gade – 2.0.5
Search Exclude: by Roman Pronskiy – 1.3.0
Show Hooks: by rafiq91
exlac – 0.4

Simple History: by P?r Thernstr?m – 3.3.1
Smart Manager - WooCommerce Advanced Bulk Edit, Inventory Management & more…: by StoreApps – 7.4.0
User Menus: by Code Atlantic – 1.3.1
User Role Editor: by Vladimir Garagulya – 4.63.2
WooCommerce B2B: by Code4Life – 3.1.2
WooCommerce B2B Sales Agents: by Code4Life – 1.2.4
WooCommerce PDF Invoices & Packing Slips Premium Templates: by Ewout Fernhout – 2.9.4
Woocommerce Product Feature Video: by motifcreatives – 2.0.3
WooCommerce Shipping & Tax: by WooCommerce – 2.2.1
Woocommerce Variations Table - Grid | VestaThemes.com: by Spyros Vlachopoulos – 1.3.10
Woo Login Redirect: by WP Doctor – 2.2.4
Wordfence Security: by Wordfence – 7.8.2
WordPress Importer: by wordpressdotorg – 0.8
WP-Members: by Chad Butler – 3.4.6
WP All Export: by Soflyy – 1.3.8
WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.5
WP All Export Pro: by Soflyy – 1.8.1
WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 3.3.4
WP All Import Pro: by Soflyy – 4.7.8
WP Fastest Cache: by Emre Vona – 1.1.0
WP File Manager: by mndpsingh287 – 7.1.7
WP Import Export Lite: by VJInfotech – 3.9.24
WP Store Locator: by Tijmen Smit – 2.2.235
WP Store Locator - CSV Manager: by Tijmen Smit – 1.0.2
WunderAutomation: by Wundermatics – 1.9.0
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
Yoast SEO: by Team Yoast – 20.0

Must Use Plugins (1)

Health Check Troubleshooting Mode: by – 1.8.1

Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
Thousand Separator: .
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
instock (instock)
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: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop base: #522 - /shop-2/
Carrello: #523 - /cart-2/
Pagamento: #12 - /checkout/
Il mio account: #13 - /my-account/
Termini e condizioni: ?</img> La pagina non è impostata

Theme

Name: Twenty Twenty-Two
Version: 1.3
Author URL: https://www.ads-software.com/
Child Theme: ?</img> – Se stai modificando WooCommerce o un tema genitore che non hai costruito personalmente
ti consigliamo di utilizzare un tema child. Vedi: Come creare un tema child

WooCommerce Support: ?</img>

Templates

Overrides: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
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

Daily Cron: ?</img> Next scheduled: 2023-01-27 15:35:08 +01:00
Options: ?</img>
Notes: 22
Onboarding: completed

Action Scheduler

Operazione annullata: 1
Oldest: 2023-01-26 15:38:48 +0100
Newest: 2023-01-26 15:38:48 +0100

Completato: 85.564
Oldest: 2022-07-26 19:03:26 +0200
Newest: 2023-01-26 19:35:20 +0100

In attesa: 74
Oldest: 2023-01-26 19:35:34 +0100
Newest: 2023-02-01 22:13:11 +0100

Status report information

Generated at: 2023-01-26 19:35:50 +01:00