• Resolved VUUB

    (@vuubnet)


    Hi,

    Our problem started two weeks ago. Due to receiving a large number of orders, we sometimes have to manually change the order status. This process used to take a maximum of 2 seconds, but now it takes at least 8 seconds.

    Despite removing all plugins and themes for testing, and not experiencing any slowness on the site frontend or even in the WordPress admin area, we are only facing this delay when changing the order status. We are seeking your support to resolve this issue.

    `
    ### WordPress Environment ###
    
    WordPress address (URL): https://poshet.com.tr
    Site address (URL): https://poshet.com.tr
    WC Version: 8.3.1
    REST API Version: ? 8.3.1
    WC Blocks Version: ? 11.4.9
    Action Scheduler Version: ? 3.6.4
    Log Directory Writable: ?
    WP Version: 6.4.1
    WP Multisite: –
    WP Memory Limit: 512 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: tr_TR
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 64 MB
    PHP Time Limit: 180
    PHP Max Input Vars: 3000
    cURL Version: 7.87.0
    OpenSSL/1.1.1p
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.6.15-MariaDB-cll-lve
    Max Upload Size: 64 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 8.3.1
    WC Database Prefix: vcWcsAsP_
    Toplam veritaban? boyutu: 2908.79MB
    Veritaban? veri boyutu: 1520.26MB
    Veritaban? indis boyutu: 1388.53MB
    vcWcsAsP_woocommerce_sessions: Veriler: 7.09 MB + Dizin: 0.09 MB + Motor InnoDB
    vcWcsAsP_woocommerce_api_keys: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_woocommerce_attribute_taxonomies: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_woocommerce_downloadable_product_permissions: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
    vcWcsAsP_woocommerce_order_items: Veriler: 7.52 MB + Dizin: 2.52 MB + Motor InnoDB
    vcWcsAsP_woocommerce_order_itemmeta: Veriler: 49.58 MB + Dizin: 38.11 MB + Motor InnoDB
    vcWcsAsP_woocommerce_tax_rates: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
    vcWcsAsP_woocommerce_tax_rate_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_woocommerce_shipping_zones: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_woocommerce_shipping_zone_locations: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_woocommerce_shipping_zone_methods: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_woocommerce_payment_tokens: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_woocommerce_payment_tokenmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_woocommerce_log: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_actionscheduler_actions: Veriler: 16.55 MB + Dizin: 12.61 MB + Motor InnoDB
    vcWcsAsP_actionscheduler_claims: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_actionscheduler_groups: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_actionscheduler_logs: Veriler: 14.52 MB + Dizin: 8.03 MB + Motor InnoDB
    vcWcsAsP_berocket_termmeta: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_commentmeta: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
    vcWcsAsP_comments: Veriler: 53.59 MB + Dizin: 52.20 MB + Motor InnoDB
    vcWcsAsP_duplicator_pro_entities: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_duplicator_pro_packages: Veriler: 0.11 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_easywpsmtp_debug_events: Veriler: 9.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_easywpsmtp_tasks_meta: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_e_events: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_iconic_woothumbs_cache: Veriler: 1.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_iconic_woo_linked_variations: Veriler: 0.23 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_intense_sozlesmeler: Veriler: 670.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_links: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_litespeed_avatar: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_litespeed_url: Veriler: 0.09 MB + Dizin: 0.09 MB + Motor InnoDB
    vcWcsAsP_litespeed_url_file: Veriler: 0.02 MB + Dizin: 0.08 MB + Motor InnoDB
    vcWcsAsP_options: Veriler: 64.22 MB + Dizin: 9.19 MB + Motor InnoDB
    vcWcsAsP_pandasms_gonderimler: Veriler: 8.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_pandasms_gonderim_sablonlari: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_pandasms_gonderim_tetikleyicileri: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_pandasms_talepleri: Veriler: 12.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_paytr_iframe_transaction: Veriler: 3.52 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_postmeta: Veriler: 478.00 MB + Dizin: 1118.59 MB + Motor InnoDB
    vcWcsAsP_posts: Veriler: 50.56 MB + Dizin: 33.16 MB + Motor InnoDB
    vcWcsAsP_sendeo_cities: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_sendeo_districts: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_stock_notifier_popular_product: Veriler: 0.34 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_termmeta: Veriler: 0.08 MB + Dizin: 0.22 MB + Motor InnoDB
    vcWcsAsP_terms: Veriler: 0.05 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_term_relationships: Veriler: 5.52 MB + Dizin: 2.52 MB + Motor InnoDB
    vcWcsAsP_term_taxonomy: Veriler: 0.05 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_tm_taskmeta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_tm_tasks: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_trp_gettext_tr_tr: Veriler: 0.48 MB + Dizin: 0.34 MB + Motor InnoDB
    vcWcsAsP_trp_original_meta: Veriler: 0.02 MB + Dizin: 0.05 MB + Motor InnoDB
    vcWcsAsP_ups_areas: Veriler: 0.38 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_ups_cities: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_usermeta: Veriler: 42.63 MB + Dizin: 86.31 MB + Motor InnoDB
    vcWcsAsP_users: Veriler: 3.52 MB + Dizin: 2.73 MB + Motor InnoDB
    vcWcsAsP_wc_admin_notes: Veriler: 0.05 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wc_admin_note_actions: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_wc_category_lookup: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wc_customer_lookup: Veriler: 1.52 MB + Dizin: 0.72 MB + Motor InnoDB
    vcWcsAsP_wc_download_log: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_wc_orders: Veriler: 0.02 MB + Dizin: 0.11 MB + Motor InnoDB
    vcWcsAsP_wc_orders_meta: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_wc_order_addresses: Veriler: 0.02 MB + Dizin: 0.06 MB + Motor InnoDB
    vcWcsAsP_wc_order_coupon_lookup: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_wc_order_operational_data: Veriler: 0.02 MB + Dizin: 0.03 MB + Motor InnoDB
    vcWcsAsP_wc_order_product_lookup: Veriler: 4.52 MB + Dizin: 6.06 MB + Motor InnoDB
    vcWcsAsP_wc_order_stats: Veriler: 2.52 MB + Dizin: 1.28 MB + Motor InnoDB
    vcWcsAsP_wc_order_tax_lookup: Veriler: 3.52 MB + Dizin: 3.03 MB + Motor InnoDB
    vcWcsAsP_wc_product_attributes_lookup: Veriler: 1.52 MB + Dizin: 0.50 MB + Motor InnoDB
    vcWcsAsP_wc_product_download_directories: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_wc_product_meta_lookup: Veriler: 3.52 MB + Dizin: 9.09 MB + Motor InnoDB
    vcWcsAsP_wc_rate_limits: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_wc_reserved_stock: Veriler: 0.45 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wc_tax_rate_classes: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_wc_webhooks: Veriler: 0.02 MB + Dizin: 0.02 MB + Motor InnoDB
    vcWcsAsP_wpmelon_advbedit_temp: Veriler: 0.20 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wt_iew_action_history: Veriler: 0.33 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wt_iew_cron: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wt_iew_ftp: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    vcWcsAsP_wt_iew_mapping_template: Veriler: 0.02 MB + Dizin: 0.00 MB + Motor InnoDB
    
    ### Post Type Counts ###
    
    attachment: 131373
    awl-labels: 1
    br_labels: 2
    cpt_iconic_wlv: 1924
    custom_css: 1
    custom_order_status: 10
    custom-css-js: 3
    customize_changeset: 23
    dvfaq: 1
    easy_contract: 2
    elementor_library: 25
    itsec-dash-card: 6
    itsec-dashboard: 1
    language_switcher: 4
    mc4wp-form: 1
    mss: 2
    nav_menu_item: 151
    order_status: 7
    page: 32
    pi_dpmw_rules: 1
    popup: 2
    popup_theme: 8
    post: 3
    pp_video_block: 1
    product: 4011
    product_variation: 9081
    revision: 2
    rey-global-sections: 45
    shop_coupon: 21
    shop_order: 16686
    shop_order_refund: 1055
    size-chart: 18
    stock_notifier: 2745
    wafs: 1
    wmpc-trash: 12965
    woolinkedvariation: 1
    wpclv: 1
    wznd_giftcard: 1
    yaymail_template: 11
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (22) ###
    
    WooCommerce i?in ?deme y?ntemleri ücretleri ve indirimleri: (Tyche Softwares) – 2.11.0
    WooCommerce i?in Mal Maliyeti: (WPFactory) – 3.1.3
    WooCommerce i?in ?zel Sipari? Durumu: (Tyche Softwares) – 2.3.0
    Easy WP SMTP: (Easy WP SMTP) – 2.2.0
    Elementor: (Elementor.com) – 3.17.1
    Gift Wrapping for WooCommerce: (Pexle Chris
    Theo Gkitsos) – 1.2.1
    
    shipmendo: (grilabs) – 2.1
    WooCommerce Linked Variations by Iconic: (Iconic ) – 1.6.1
    Intense Mesafeli Sat?? S?zl. & ?n Bilg. Formu Eklentisi: (Intense Yaz?l?m) – 1.16.0
    LiteSpeed Cache: (LiteSpeed Technologies) – 5.7.0.1
    PandaSMS for WooCommerce: (Intense Yaz?l?m Ltd.) – 3.18.3
    PayTR Sanal POS WooCommerce - iFrame API: (PayTR ?deme ve Elektronik Para Kurulu?u A.?.) – 2.0.4
    Rey Core: (ReyTheme) – 2.8.2
    CTX Feed: (WebAppick) – 6.3.2
    Checkout Field Editor for WooCommerce: (ThemeHigh) – 2.0.0
    Premmerce Permalink Manager for WooCommerce: (Premmerce) – 2.3.9
    WooCommerce Advanced Bulk Edit: (George Iron & Yas G.) – 5.2.1
    WooCommerce Conditional Shipping and Payments: (WooCommerce) – 1.14.5
    WooCommerce: (Automattic) – 8.3.1
    WP-Optimize Premium - Clean, Compress, Cache: (David Anderson
    Ruhani Rabin
    Team Updraft) – 3.2.20
    
    WP SMS Fonksiyonlar?: (grilabs) – 1.2.8
    WPS Hide Login: (WPServeur
    NicolasKulka
    wpformation) – 1.9.9
    
    
    ### Inactive Plugins (12) ###
    
    Advanced Order Export For WooCommerce: (AlgolPlus) – 3.4.3
    CURCY - WooCommerce Multi Currency Premium: (VillaTheme) – 2.2.5
    Flexible Shipping: (Octolize) – 4.23.1
    Flexible Shipping PRO: (Octolize) – 2.16.4
    FOX - Currency Switcher Professional for WooCommerce: (realmag777) – 2.4.1.3
    Loco Translate: (Tim Whitlock) – 2.6.6
    Maintenance: (WebFactory Ltd) – 4.08
    Simple Custom CSS and JS: (SilkyPress.com) – 3.45
    Stock Notifier for WooCommerce: (WPPOOL) – 2.1.5
    Stock Notifier for WooCommerce Ultimate: (WPPOOL) – 1.0.7
    Weglot Translate: (Weglot Translate team) – 4.2.2
    WooCommerce Price Based on Country: (Oscar Gare) – 3.3.2
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: TRY (?)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    bundled (bundled)
    external (external)
    grouped (grouped)
    mix and match (mix-and-match)
    simple (simple)
    variable (variable)
    woosb (woosb)
    
    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 screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –
    
    ### WC Pages ###
    
    Ma?aza giri? sayfas?: #2750 - /magaza/
    Sepet sayfas?: ? Sayfa [woocommerce_cart] k?sa kodunu veya woocommerce/cart blo?unu i?ermiyor.
    ?deme sayfas?: ? Sayfa [woocommerce_checkout] k?sa kodunu veya woocommerce/checkout blo?unu i?ermiyor.
    Hesab?m sayfas?: #2751 - /musteri-paneli/
    ?artlar ve ko?ullar: ? Sayfa kimli?i ayarland? ancak sayfa mevcut de?il
    
    ### Theme ###
    
    Name: Rey Child
    Version: 1.0.0
    Author URL: https://twitter.com/mariushoria
    Child Theme: ?
    Parent Theme Name: Rey
    Parent Theme Version: 2.8.2
    Parent Theme Author URL: https://twitter.com/mariushoria
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/cart/cart-item-data.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/cart/mini-cart.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/loop-orderby.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/loop-pagination-infinite.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/loop-price.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/loop-result-count.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/header-account-menu.php - sürümü güncel de?il. ?ekirdek sürüm: 2.6.0
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-simple-add-to-cart-button.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-variation-add-to-cart-button.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-variation-data.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-meta.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-product-attributes.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-product-image.php
    /home/u868747951/domains/poshet.com.tr/public_html/wp-content/plugins/rey-core/template-parts/woocommerce/single-tabs.php
    
    Outdated Templates: ?
    					
    					
    						Nas?l güncelle?tirilece?ini ??renin
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    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
    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: customize-store
    minified-js
    new-product-management-experience
    product-virtual-downloadable
    product-external-affiliate
    settings
    async-product-editor-category-field
    
    Daily Cron: ? Next scheduled: 2023-11-23 08:52:23 +03:00
    Options: ?
    Notes: 27
    Onboarding: skipped
    
    ### Action Scheduler ###
    
    Tamamla: 52.618
    Oldest: 2023-10-22 08:55:25 +0000
    Newest: 2023-11-22 08:42:23 +0000
    
    Bekleyen: 6
    Oldest: 2023-11-22 08:55:26 +0000
    Newest: 2023-11-22 20:21:24 +0000
    
    
    ### Status report information ###
    
    Generated at: 2023-11-22 11:55:33 +03:00
    `

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hey @vuubnet,

    Thanks for reaching out!

    It looks like you have recently been experiencing a performance issue with regard to manually updating order status’, is this correct?

    Our problem started two weeks ago

    Do you recall any changes/updates made to the site or server before this issue first popped up?

    Toplam veritaban? boyutu: 2908.79MB

    I am able to see that you have quite a large database. I’d suggest optimizing the database and see if this makes any difference. You can try using the free WP-Optimize plugin for this.

    If the issue is still present, can you check if there are any console errors when updating the order status and share these with us here? You can read more about?using your browser console to identify errors here.

    In the meantime, I’d suggest installing the?Query Monitor?plugin on your site. It might share details?on what may be causing the issue.

    Let us know what you find!

    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Howdy,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Order Status Change Takes 8 Sec’ is closed to new replies.