How to improve the performance of WooCommerce Rest API?

Hi Team,

Currently, the woocommerce endpoints take a long time to respond i.e. more than 5 seconds. We have added a plugin called WP REST Cache. This helps in the improvement of performance of all the GET rest API. But few API, like add item to cart, update cart, update address in cart, create an order takes a long time to respond. Is there anyway to improve the performance of these API? Please find the system report of our website below :

System Report



WordPress Environment<br><br>WordPress address (URL): https://braverslun.is<br>Site address (URL): https://braverslun.is<br>WC Version: 9.3.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.8.2<br>Log Directory Writable: ✔<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: is_IS<br>External object cache: ✔ Server Environment<br><br>Server Info: nginx<br>PHP Version: 8.1.30<br>PHP Post Max Size: 2 GB<br>PHP Time Limit: 1200<br>PHP Max Input Vars: 6144<br>cURL Version: 8.10.1<br>OpenSSL/1.1.1n<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.6.18-MariaDB-log<br>Max Upload Size: 2 GB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database<br><br>WC Database Version: 9.3.3<br>WC Database Prefix: wp_<br>Total Database Size: 618.27MB<br>Database Data Size: 402.03MB<br>Database Index Size: 216.24MB<br>wp_woocommerce_sessions: Data: 5.02MB + Index: 0.13MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 4.52MB + Index: 1.52MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 36.56MB + Index: 28.09MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 11.02MB + Index: 13.16MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 11.08MB + Index: 4.03MB + Engine InnoDB<br>wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_atum_product_data: Data: 0.41MB + Index: 0.27MB + Engine InnoDB<br>wp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cartflows_ca_cart_abandonment: Data: 4.52MB + Index: 0.11MB + Engine InnoDB<br>wp_cartflows_ca_email_history: Data: 0.11MB + Index: 0.13MB + Engine InnoDB<br>wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_cky_banners: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookie_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 24.55MB + Index: 15.09MB + Engine InnoDB<br>wp_dropp_consignments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB<br>wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_foosales_square_checkouts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_foosales_square_devices: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_foosales_square_refunds: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_budget_recommendations: Data: 0.19MB + Index: 0.14MB + Engine InnoDB<br>wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_hfcm_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_jetpack_sync_queue: Data: 0.28MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 0.16MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 14.03MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 5.09MB + Index: 1.11MB + Engine InnoDB<br>wp_postmeta: Data: 219.75MB + Index: 124.02MB + Engine InnoDB<br>wp_posts: Data: 44.55MB + Index: 11.80MB + Engine InnoDB<br>wp_pos_warehouse: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_stock_log: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_termmeta: Data: 0.13MB + Index: 0.16MB + Engine InnoDB<br>wp_terms: Data: 0.03MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.22MB + Index: 0.13MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_updraftcentral_sitemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_updraftcentral_sites: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_updraftcentral_site_temporary_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_updraftcentral_user_cron: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB<br>wp_users: Data: 0.20MB + Index: 0.19MB + Engine InnoDB<br>wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 1.52MB + Index: 0.64MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.28MB + Index: 0.64MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 5.52MB + Index: 6.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 3.52MB + Index: 2.42MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 1.50MB + Index: 1.00MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wepos_cashier_outlet: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wepos_counters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wepos_login: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wepos_outlets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpklist_template_data: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wrc_caches: Data: 0.20MB + Index: 0.20MB + Engine InnoDB<br>wp_wrc_relations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB Post Type Counts<br><br>acoplw_badges: 1<br>acoplw_prod_list: 1<br>adt_product_feed: 3<br>amp_validated_url: 2<br>attachment: 4205<br>atum_supplier: 1<br>customize_changeset: 254<br>custom_css: 1<br>custom_order_status: 5<br>elementor_library: 34<br>foosales_payment: 5353<br>jb_store_css: 7<br>jetpack_migration: 2<br>jp_img_sitemap: 12<br>jp_img_sitemap_index: 6<br>jp_sitemap: 6<br>jp_sitemap_master: 6<br>jp_vid_sitemap: 6<br>nav_menu_item: 43<br>op_transaction: 60<br>op_z_report: 44<br>page: 21<br>post: 5<br>product: 605<br>product_variation: 1177<br>revision: 1946<br>shop_coupon: 36<br>shop_order: 40408<br>shop_order_refund: 111<br>wcpa_pt_forms: 7<br>woo_product_tab: 2<br>wpcf7_contact_form: 3<br>wpcode: 2<br>wp_global_styles: 1<br>wp_template_part: 2<br>yith_slide: 2<br>yith_slider: 2<br>yith_wcps_type: 2<br>_op_receipt: 2<br>_op_register: 2 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (62)<br><br>Acowebs Product Labels For Woocommerce: by Acowebs – 1.5.7<br>Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.3<br>AMP: by AMP Project Contributors – 2.5.4<br>ATUM Inventory Management for WooCommerce: by Stock Management Labs™ – 1.9.40<br>Barcode Printing for WooCommerce & Contact Form 7 - (business): by UkrSolution – 3.1.5<br>Booster Plus for WooCommerce: by Pluggabl LLC – 7.2.3<br>Catecut Universal: by Unibrix – 2.0<br>Classic Editor: by WordPress Contributors – 1.6.5<br>CoBlocks: by GoDaddy – 3.1.13<br>CookieYes | GDPR Cookie Consent: by CookieYes – 3.2.6<br>Crowdsignal Forms: by Automattic – 1.7.2<br>Custom Order Status for WooCommerce Pro: by Tyche Softwares – 2.0.1<br>Duplicate Page: by mndpsingh287 – 4.5.4<br>Elementor Pro: by Elementor.com – 3.22.1<br>Elementor: by Elementor.com – 3.24.1<br>Essential Addons for Elementor: by WPDeveloper – 6.0.6<br>F4 Total Stock Value for WooCommerce: by FAKTOR VIER – 2.0.6<br>Facebook for WooCommerce: by Facebook – 3.2.10<br>Filester - File Manager Pro: by Ninja Team – 1.8.4<br>FooSales — Point of Sale (POS) for WooCommerce: by FooSales – 1.38.9<br>Site Kit by Google: by Google – 1.136.0<br>Header Footer Code Manager: by DraftPress – 1.1.39<br>Image Optimizer - Compress, Resize and Optimize Images: by Elementor.com – 1.5.4<br>WPCode Lite: by WPCode – 2.2.2<br>Jetpack Boost: by Automattic - Jetpack Site Speed team – 3.5.1<br>Jetpack: by Automattic – 13.9<br>KORTA: by KORTA – 0.1<br>Layout Grid: by Automattic – 1.8.4<br>Loco Translate: by Tim Whitlock – 2.6.11<br>Mailchimp for WooCommerce: by Mailchimp – 4.4.1<br>Netgíró Payment gateway for Woocommerce: by Netgíró – 4.2.1<br>Page Optimize: by Automattic – 0.5.5<br>Payment Gateway via Valitor for WooCommerce: by Tactica – 1.9.37<br>WooCommerce Pei Payment Gateway: by Premis – 3.06<br>PixelYourSite: by PixelYourSite – 9.7.2<br>Pósturinn's Shipping with WooCommerce: by Pósturinn – 1.3.1<br>WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.6.2<br>Product Sales Report for WooCommerce: by WP Zone – 1.5.6<br>Rapyd Payments: by Rapyd – 1.1.8<br>Simple-JWT-Login: by Nicu Micle – 3.5.6<br>Menu JSON Categories Extension: by Stokkur.is – 1.0.0<br>EIMSKIP: by smartmedia – 2.2.2<br>What The File: by Never5 – 1.6.0<br>Boost Sales for WooCommerce: by VillaTheme – 1.2.12<br>WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.3.0<br>WooCommerce Custom Product Addons Free: by Acowebs – 3.0.9<br>Discount Rules PRO 2.0: by Flycart – 2.6.4<br>Discount Rules Core: by Flycart – 2.6.6<br>Category Discount Woocommerce: by QuanticEdge – 4.14<br>Product Feed PRO for WooCommerce: by AdTribes.io – 13.3.7<br>WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.14<br>Variation Swatches for WooCommerce: by Emran Ahmed – 2.1.2<br>Customizer for WooCommerce: by SkyVerge – 2.8.0<br>WooCommerce Direct Checkout: by QuadLayers – 3.3.9<br>Booster for WooCommerce: by Pluggabl LLC – 7.2.3<br>Aur Payments: by Aur – 1.0.4<br>Product SKU Generator for WooCommerce: by SkyVerge – 2.5.0<br>WooCommerce Product Tabs (Free): by Barn2 Plugins – 2.1.6<br>WooCommerce Shipping & Tax: by WooCommerce – 2.8.2<br>WooCommerce: by Automattic – 9.3.3<br>WP Mail SMTP: by WP Mail SMTP – 4.1.1<br>WP REST Cache: by Acato – 2024.2.3 Inactive Plugins (13)<br><br>Barcode Printing for WooCommerce & Contact Form 7 - (basic): by UkrSolution – 3.3.13<br>Catecut Plugin: by Valentyn Victorovich Moroz – 1.0<br>Catecut Universal: by Unibrix – 2.0<br>Contact Form 7: by Takayuki Miyoshi – 5.9.8<br>Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.4.18<br>Elementor Beta (Developer Edition): by Elementor.com – 1.1.1<br>Google for WooCommerce: by WooCommerce – 2.8.6<br>Gutenberg: by Gutenberg Team – 19.2.0<br>wePOS - Point Of Sale (POS) for WooCommerce: by weDevs – 1.2.6<br>wePOS - Pro: by weDevs – 1.1.2<br>WooCommerce Boost Sales Premium: by Andy Ha (villatheme.com) – 1.4.7<br>WooCommerce Order paid webhook: by Krokedil – 1.0<br>WooCommerce Shipping: by WooCommerce – 1.1.5 Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php<br>object-cache.php: Memcached Must Use Plugins (3)<br><br>Elementor Safe Mode: by Elementor.com – 1.0.0<br>wpcomsh-loader.php: by –<br>WP REST Cache - Must-Use Plugin: by Richard Korthuis - Acato – 2021.3.0 Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: ISK (kr.)<br>Currency Position: right_space<br>Thousand Separator: .<br>Decimal Separator: .<br>Number of Decimals: 0<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br>wbs_bundle (wbs_bundle)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 18 MB WC Pages<br><br>Shop base: #21457 - /shop/<br>Cart: #34 - /cart/ - Contains the [woocommerce_cart] shortcode<br>Checkout: #1714 - /klara-pontun/ - Contains the [woocommerce_checkout] shortcode<br>My account: #1715 - /privacy-policy/my-account-2/<br>Terms and conditions: #7324 - /privacy-policy/ Theme<br><br>Name: YITH Proteo Child<br>Version: 1.0.1<br>Author URL:<br>Child Theme: ✔<br>Parent Theme Name: YITH Proteo<br>Parent Theme Version: 1.5.5 – 1.9.3 is available<br>Parent Theme Author URL: https://yithemes.com<br>WooCommerce Support: ✔ Templates<br><br>Overrides: yith-proteo/woocommerce/checkout/form-checkout.php<br>yith-proteo/woocommerce/content-product.php<br>yith-proteo/woocommerce/content-single-product.php<br>yith-proteo/woocommerce/content-widget-product.php<br>yith-proteo/woocommerce/single-product/meta.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br><br>Daily Cron: ✔ Next scheduled: 2024-10-07 16:15:19 +00:00<br>Options: ✔<br>Notes: 5<br>Onboarding: completed Action Scheduler<br><br>Canceled: 8<br>Oldest: 2024-09-10 17:13:27 +0000<br>Newest: 2024-10-04 14:04:42 +0000<br><br>Complete: 6,405<br>Oldest: 2024-09-06 11:57:56 +0000<br>Newest: 2024-10-07 11:28:50 +0000<br><br>Failed: 780<br>Oldest: 2022-04-12 16:49:01 +0000<br>Newest: 2024-09-10 09:47:07 +0000<br><br>Pending: 10<br>Oldest: 2024-10-07 14:14:56 +0000<br>Newest: 2024-10-10 11:12:50 +0000 Status report information<br><br>Generated at: 2024-10-07 11:35:45 +00:00<br>

• This topic was modified 1 year, 11 months ago by pujithamutyala.