Topwin999 login registration philippines.Claim Your Free 999 Pesos Bonus Today

Resolved patrixxxk
(@patrixxxk)

3 months ago
Hello,

We are experiencing significant performance issues with our WooCommerce store, resulting in extremely slow backend and frontend loading times. We have approximately 6,000 products (3,000 in Czech and 3,000 in Slovak) and use the WPML plugin for multilingual support.

We have conducted extensive troubleshooting to isolate the cause of these performance problems, including:
- Profiling: We used Code Profiler Pro and Query Monitor to identify performance bottlenecks.
- Database Optimization: We performed database cleaning and optimization procedures.
- Staging Site Testing: We created a staging site and methodically tested with all plugins and themes. We deactivated all plugins and switched to a default theme. Then, we reactivated plugins one by one.
Through this testing, we definitively identified WooCommerce as the primary source of the performance issues. When WooCommerce is deactivated, the site performs optimally. When WooCommerce is active, both the backend and frontend become extremely slow.

Specifically, we’ve observed:
- High Memory Usage on Single Product Pages: A single product page load consumes approximately 196MB of memory.
Our site runs on a VPS server, so server resources are not the limiting factor. This issue appears to be directly related to the WooCommerce plugin’s interaction with our product catalog (especially with the WPML integration and maybe Elementor).

We have also worked with WPML support, and they have investigated the issue from their end. They have confirmed that there are no apparent problems or conflicts from the WPML plugin itself.

Screenshots:
https://prnt.sc/bGIZB8XyjM2w
https://prnt.sc/twVkf9CWMoVV
Product page Query monitor and queries amount: https://prnt.sc/H-lG5dv1JrwU

Viewing 7 replies - 1 through 7 (of 7 total)

Plugin Support

Zubair Zahid (woo-hc)

(@doublezed2)

3 months ago

Hello patrixxxk,

Thank you for contacting WooCommerce support.

I understand you’re experiencing significant performance issues with your WooCommerce store, especially with high memory usage on single product pages.

To confirm, have you tested the site with only WooCommerce and a default theme like Storefront active? How does the performance compare to when all plugins are active?
It would be helpful if you could record a video and show me the loading time of both scenarios.

To better understand your setup, please provide a copy of your site’s System Status Report.
You can find it under WooCommerce > Status. Click Get system report and then Copy for support.

Looking forward to your response. ??

This reply was modified 3 months ago by Zubair Zahid (woo-hc). Reason: Rewriting the response

Thread Starter

patrixxxk

(@patrixxxk)

3 months ago

Hello Zubair,
Sending the System report, is there a way to send the video in a private chat? If not, sadly I can’t record it, yes I have tried to change the theme to Storefront and also keeping all the plugins active / deactived, turning in back one by one, the load time was the same.


### WordPress Environment ###

WordPress address (URL): 
Site address (URL): 
WC Version: 9.4.1
Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
Action Scheduler Version: ? 3.8.2
Log Directory Writable: ?
WP Version: ? 6.6.2 - Je dostupná nová verze WordPress (6.7.1)
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: –
Language: cs_CZ
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 8.3.12
PHP Post Max Size: 256 MB
PHP Time Limit: 300
PHP Max Input Vars: 20000
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 8.0.36
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 9.4.1
WC Database Prefix: kvfoyo_
Celková velikost databáze: 1461.05MB
Velikost dat databáze: 1134.59MB
Velikost indexu databáze: 326.46MB
kvfoyo_woocommerce_sessions: Data: 119.02MB + Index: 6.02MB + Engine InnoDB
kvfoyo_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_woocommerce_order_items: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
kvfoyo_woocommerce_order_itemmeta: Data: 9.52MB + Index: 8.03MB + Engine InnoDB
kvfoyo_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kvfoyo_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_actionscheduler_actions: Data: 64.59MB + Index: 44.36MB + Engine InnoDB
kvfoyo_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_actionscheduler_logs: Data: 34.08MB + Index: 27.11MB + Engine InnoDB
kvfoyo_automatewoo_abandoned_carts: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
kvfoyo_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_automatewoo_customers: Data: 0.34MB + Index: 0.75MB + Engine InnoDB
kvfoyo_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_automatewoo_guests: Data: 0.30MB + Index: 0.45MB + Engine InnoDB
kvfoyo_automatewoo_log_meta: Data: 1.52MB + Index: 0.56MB + Engine InnoDB
kvfoyo_automatewoo_logs: Data: 0.16MB + Index: 0.27MB + Engine InnoDB
kvfoyo_automatewoo_queue: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
kvfoyo_automatewoo_queue_meta: Data: 0.08MB + Index: 0.11MB + Engine InnoDB
kvfoyo_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cleantalk_connection_reports: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cleantalk_sessions: Data: 56.58MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cleantalk_sfw: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cleantalk_sfw_personal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
kvfoyo_comments: Data: 3.52MB + Index: 3.39MB + Engine InnoDB
kvfoyo_dgwt_wcas_index: Data: 4.52MB + Index: 0.13MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_cache_cs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_cache_sk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_doclist_cs: Data: 15.52MB + Index: 13.03MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_doclist_sk: Data: 15.52MB + Index: 13.03MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_wordlist_cs: Data: 1.52MB + Index: 0.45MB + Engine InnoDB
kvfoyo_dgwt_wcas_invindex_wordlist_sk: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
kvfoyo_dgwt_wcas_stats: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_dgwt_wcas_tax_index: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
kvfoyo_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_e_submissions: Data: 0.06MB + Index: 0.27MB + Engine InnoDB
kvfoyo_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
kvfoyo_e_submissions_values: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
kvfoyo_gdpr_cc_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB
kvfoyo_gla_merchant_issues: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_background_task: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_cms_nav_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_content_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_core_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_icl_languages_translations: Data: 0.19MB + Index: 0.09MB + Engine InnoDB
kvfoyo_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_message_status: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_icl_mo_files_domains: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_node: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_string_positions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_string_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_icl_string_translations: Data: 5.52MB + Index: 3.03MB + Engine InnoDB
kvfoyo_icl_strings: Data: 7.52MB + Index: 11.09MB + Engine InnoDB
kvfoyo_icl_translate: Data: 118.63MB + Index: 4.52MB + Engine InnoDB
kvfoyo_icl_translate_job: Data: 1.52MB + Index: 0.28MB + Engine InnoDB
kvfoyo_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_icl_translation_status: Data: 140.55MB + Index: 1.52MB + Engine InnoDB
kvfoyo_icl_translations: Data: 4.52MB + Index: 9.06MB + Engine InnoDB
kvfoyo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_options: Data: 36.48MB + Index: 4.13MB + Engine InnoDB
kvfoyo_packetery_carrier: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_packetery_customs_declaration: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_packetery_customs_declaration_item: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_packetery_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_packetery_order: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxe_exports: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxe_posts: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxe_templates: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_hash: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_images: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_imports: Data: 1.50MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_posts: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pmxi_templates: Data: 0.44MB + Index: 0.00MB + Engine InnoDB
kvfoyo_post_entries_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_postmeta: Data: 233.77MB + Index: 74.94MB + Engine InnoDB
kvfoyo_posts: Data: 38.56MB + Index: 9.06MB + Engine InnoDB
kvfoyo_pys_stat_landing: Data: 0.16MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_order: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_product_order: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_utm_campaing: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_utm_content: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_pys_stat_utm_term: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
kvfoyo_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rank_math_analytics_ga: Data: 0.33MB + Index: 0.30MB + Engine InnoDB
kvfoyo_rank_math_analytics_gsc: Data: 3.52MB + Index: 5.88MB + Engine InnoDB
kvfoyo_rank_math_analytics_inspections: Data: 5.52MB + Index: 0.42MB + Engine InnoDB
kvfoyo_rank_math_analytics_keyword_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_rank_math_analytics_objects: Data: 3.52MB + Index: 1.52MB + Engine InnoDB
kvfoyo_rank_math_internal_links: Data: 1.52MB + Index: 0.20MB + Engine InnoDB
kvfoyo_rank_math_internal_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_asset_seo_redirect: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_rcb_consent: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
kvfoyo_rcb_revision: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_scan: Data: 16.55MB + Index: 5.56MB + Engine InnoDB
kvfoyo_rcb_scan_markup: Data: 6.52MB + Index: 0.36MB + Engine InnoDB
kvfoyo_rcb_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_stats_buttons_clicked: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_tcf_vendors: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_template: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
kvfoyo_rcb_template_translation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_real_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_sbi_feed_caches: Data: 0.27MB + Index: 0.02MB + Engine InnoDB
kvfoyo_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_sbi_instagram_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_slovakparcelservice_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_slovakparcelservice_zipcity: Data: 0.41MB + Index: 0.38MB + Engine InnoDB
kvfoyo_sm_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_term_relationships: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
kvfoyo_term_taxonomy: Data: 0.22MB + Index: 0.09MB + Engine InnoDB
kvfoyo_termmeta: Data: 1.52MB + Index: 0.31MB + Engine InnoDB
kvfoyo_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
kvfoyo_tm_taskmeta: Data: 3.52MB + Index: 0.70MB + Engine InnoDB
kvfoyo_tm_tasks: Data: 2.52MB + Index: 0.31MB + Engine InnoDB
kvfoyo_toolset_associations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_toolset_post_guid_id: Data: 2.52MB + Index: 2.84MB + Engine InnoDB
kvfoyo_toolset_relationships: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
kvfoyo_toolset_type_sets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_trp_gettext_cs_cz: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
kvfoyo_trp_gettext_sk_sk: Data: 1.52MB + Index: 0.53MB + Engine InnoDB
kvfoyo_trp_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kvfoyo_trp_original_strings: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
kvfoyo_tzc_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_ucp_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_usermeta: Data: 2.52MB + Index: 1.94MB + Engine InnoDB
kvfoyo_users: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
kvfoyo_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wc_customer_lookup: Data: 0.30MB + Index: 0.28MB + Engine InnoDB
kvfoyo_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_wc_order_addresses: Data: 1.52MB + Index: 0.95MB + Engine InnoDB
kvfoyo_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
kvfoyo_wc_order_operational_data: Data: 1.52MB + Index: 0.33MB + Engine InnoDB
kvfoyo_wc_order_product_lookup: Data: 0.44MB + Index: 0.44MB + Engine InnoDB
kvfoyo_wc_order_stats: Data: 0.34MB + Index: 0.31MB + Engine InnoDB
kvfoyo_wc_order_tax_lookup: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
kvfoyo_wc_orders: Data: 2.52MB + Index: 1.23MB + Engine InnoDB
kvfoyo_wc_orders_meta: Data: 16.55MB + Index: 29.17MB + Engine InnoDB
kvfoyo_wc_product_attributes_lookup: Data: 2.52MB + Index: 1.52MB + Engine InnoDB
kvfoyo_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wc_product_meta_lookup: Data: 4.52MB + Index: 11.61MB + Engine InnoDB
kvfoyo_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wc_sf_log: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wcmps_cf: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wcmps_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wf_payments_log: Data: 9.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfauditevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfblockediplog: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kvfoyo_wfconfig: Data: 0.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfcrawlers: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wffilemods: Data: 11.55MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfhits: Data: 1.52MB + Index: 0.17MB + Engine InnoDB
kvfoyo_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wfissues: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
kvfoyo_wfknownfilelist: Data: 8.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wflogins: Data: 0.47MB + Index: 0.16MB + Engine InnoDB
kvfoyo_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
kvfoyo_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kvfoyo_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
kvfoyo_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_woocommerce_prl_deploymentmeta: Data: 10.52MB + Index: 0.42MB + Engine InnoDB
kvfoyo_woocommerce_prl_deployments: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
kvfoyo_woocommerce_prl_frequencies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_woocommerce_prl_generator_queue: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
kvfoyo_woocommerce_prl_tracking_conversions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
kvfoyo_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpc_accesslocks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpc_login_fails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpcode_revisions: Data: 2.52MB + Index: 0.16MB + Engine InnoDB
kvfoyo_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpie_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpify_woo_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpmailsmtp_debug_events: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wpmailsmtp_emails_log: Data: 34.02MB + Index: 0.28MB + Engine InnoDB
kvfoyo_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
kvfoyo_wps_hit: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
kvfoyo_wps_index: Data: 13.52MB + Index: 13.55MB + Engine InnoDB
kvfoyo_wps_key: Data: 0.50MB + Index: 0.30MB + Engine InnoDB
kvfoyo_wps_object_term: Data: 0.36MB + Index: 0.69MB + Engine InnoDB
kvfoyo_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
kvfoyo_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wps_uri: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
kvfoyo_wsc_collections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
ultimate_cfimporter_pro_smack_field_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 41888
aw_workflow: 3
bellows_query: 2
ckit_size_guide: 9
cms_block: 2
cookielawinfo: 6
custom_css: 2
e-floating-buttons: 1
elementor_library: 31
global_product_addon: 3
language_switcher: 4
nav_menu_item: 738
oembed_cache: 3
page: 33
pi_dpmw_rules: 1
post: 54
prl_engine: 4
product: 6149
product_variation: 3446
pys_event: 1
rank_math_schema: 2
rcb-banner-link: 1
rcb-cookie: 2
revision: 4
rm_content_editor: 1
shop_coupon: 10
shop_order: 3970
shop_order_placehold: 8
wcpf_item: 4
wcpf_project: 1
wp_block: 2
wp_global_styles: 2
wp_navigation: 4
wp_template: 4
wp-types-group: 1
wpcode: 7

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (33) ###

AutomateWoo: Autor: WooCommerce – 6.1.0 (aktualizace na verzi 6.1.3 je dostupná)
Klasické widgety: Autor: WordPress p?ispěvatelé – 0.3
Anti-Spam by CleanTalk: Autor: СleanTalk - Anti-Spam Protection  – 6.45.1
Code Profiler Pro: Autor: Jerome Bruandet ~ NinTechNet Ltd. – 1.6.8
Integrate Ecomail and Elementor Forms: Autor: Adam Kotala – 1.3.1
Ecomail: Autor: ECOMAIL.CZ – 2.1.6
Elementor Pro: Autor: Elementor.com – 3.25.2
Elementor: Autor: Elementor.com – 3.25.4
MainWP Child: Autor: MainWP – 5.2
Zásilkovna: Autor: Zásilkovna s.r.o. – 1.8.6
PixelYourSite PRO: Autor: PixelYourSite – 10.2.0.1
PixelYourSite Super Pack: Autor: PixelYourSite – 5.2.1
Post Affiliate Pro: Autor: QualityUnit – 5.19.8
Query Monitor: Autor: John Blackbourn – 3.17.0
Rank Math SEO PRO: Autor: Rank Math – 3.0.60
Rank Math SEO: Autor: Rank Math – 1.0.231
WPML Multilingual CMS: Autor: OnTheGoSystems – 4.6.13
SlovakParcelService: Autor: Solver IT s.r.o. – 2.7.0
CTX Feed Pro: Autor: WebAppick Author – 7.3.16
Comgate WooCommerce plugin: Autor: WisdomFactory
s.r.o. – 1.1.28

Woo Custom Stock Status: Autor: Softound Solutions – 1.5.9
WP Sheet Editor - WooCommerce Products (Premium): Autor: WP Sheet Editor – 1.8.13
WooCommerce Multilingual & Multicurrency: Autor: OnTheGoSystems – 5.3.8
Pay for Payment for WooCommerce: Autor: Karolína Vysko?ilová – 2.1.8
WooCommerce Product Add-Ons: Autor: Woo – 7.1.2 (aktualizace na verzi 7.2.1 je dostupná)
WooCommerce SuperFaktura: Autor: 2day.sk – 1.42.6
WooCommerce: Autor: Automattic – 9.4.1 (aktualizace na verzi 9.4.3 je dostupná)
Woodmart Core: Autor:  – 1.0.44
WP Mail SMTP Pro: Autor: WP Mail SMTP – 3.10.1
WP-Optimize - Clean, Compress, Cache: Autor: TeamUpdraft
DavidAnderson – 3.7.0

WPCode Pro: Autor: WPCode – 2.2.3
WPML String Translation: Autor: OnTheGoSystems – 3.2.14
WPML Delete Jobs (wpmlsupp-7909): Autor: WPML Support Team – 1.0

### Inactive Plugins (4) ###

Instagram Feed Pro Developer: Autor: Smash Balloon – 6.3.5
Safe SVG: Autor: 10up – 2.2.6
WooCommerce Product Recommendations: Autor: WooCommerce – 3.0.1
Wordfence Security: Autor: Wordfence – 8.0.0

### Dropin Plugins () ###

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in)

### Must Use Plugins (1) ###

Code Profiler (mu-plugin): Autor: Jerome Bruandet – 1.0

### Settings ###

Legacy API Enabled: –
Force SSL: –
Currency: CZK (K?)
Currency Position: right_space
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)
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 dn?
Level threshold: –
Log directory size: 5 MB

### WC Pages ###

Obchod: #10 - /obchod/
Ko?ík: #11 - /kosik/ -  Contains the [woocommerce_cart] shortcode
Pokladna: #226488 - /pokladna/ -  Contains the [woocommerce_checkout] shortcode
M?j ú?et: #13 - /muj-ucet/
Obchodní podmínky: #13476 - /vseobecne-obchodne-podmienky/

### Theme ###

Name: Woodmart Child
Version: 1.0.0
Author URL: https://xtemos.com
Child Theme: ?
Parent Theme Name: Woodmart
Parent Theme Version: 7.6.0 – 8.0.4 je k dispozici
Parent Theme Author URL: https://themeforest.net/user/xtemos
WooCommerce Support: ?

### Templates ###

Overrides: woodmart/woocommerce/archive-product.php
woodmart/woocommerce/cart/cart-item-data.php
woodmart/woocommerce/cart/cart.php
woodmart/woocommerce/cart/cross-sells.php
woodmart/woocommerce/cart/mini-cart.php
woodmart/woocommerce/checkout/form-checkout.php verze 3.5.0 je neaktuální. Verze jádra je 9.4.0
woodmart/woocommerce/checkout/thankyou.php
woodmart/woocommerce/content-product-cat.php
woodmart/woocommerce/content-product.php verze 3.6.0 je neaktuální. Verze jádra je 9.4.0
woodmart/woocommerce/content-single-product.php
woodmart/woocommerce/content-widget-product.php
woodmart/woocommerce/global/breadcrumb.php
woodmart/woocommerce/global/form-login.php
woodmart/woocommerce/global/quantity-input.php verze 7.8.0 je neaktuální. Verze jádra je 9.4.0
woodmart/woocommerce/loop/add-to-cart.php
woodmart/woocommerce/loop/loop-end.php
woodmart/woocommerce/loop/loop-start.php
woodmart/woocommerce/loop/no-products-found.php
woodmart/woocommerce/loop/orderby.php
woodmart/woocommerce/loop/pagination.php
woodmart/woocommerce/loop/sale-flash.php
woodmart/woocommerce/myaccount/form-login.php
woodmart/woocommerce/product-searchform.php
woodmart/woocommerce/single-product/add-to-cart/grouped.php
woodmart/woocommerce/single-product/add-to-cart/variable.php
woodmart/woocommerce/single-product/meta.php
woodmart/woocommerce/single-product/product-attributes.php
woodmart/woocommerce/single-product/product-image.php
woodmart/woocommerce/single-product/product-thumbnails.php
woodmart/woocommerce/single-product/rating.php
woodmart/woocommerce/single-product/related.php
woodmart/woocommerce/single-product/sale-flash.php
woodmart/woocommerce/single-product/tabs/description.php
woodmart/woocommerce/single-product/tabs/tabs.php
woodmart/woocommerce/single-product/title.php
woodmart/woocommerce/single-product/up-sells.php
woodmart/woocommerce/single-product-reviews.php
woodmart/woocommerce/single-product.php

Outdated Templates: ?
					
					
						Zjistěte
jak aktualizovat					 |
					
						
					
					
						Clear system status theme info cache


### 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
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store

Disabled Features: product-data-views
experimental-blocks
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
use-wp-horizon

Daily Cron: ? Next scheduled: 2024-12-17 17:36:20 +01:00
Options: ?
Notes: 59
Onboarding: skipped

### Action Scheduler ###

Canceled: 36
Oldest: 2024-11-18 18:32:36 +0100
Newest: 2024-12-15 18:35:39 +0100

Complete: 122?436
Oldest: 2024-11-18 18:31:32 +0100
Newest: 2024-12-17 14:36:19 +0100

Failed: 1?697
Oldest: 2024-01-29 11:11:38 +0100
Newest: 2024-12-17 02:12:05 +0100

Pending: 34
Oldest: 2024-12-17 14:36:21 +0100
Newest: 2024-12-23 17:58:43 +0100


### Status report information ###

Generated at: 2024-12-17 14:36:25 +01:00

This reply was modified 3 months ago by patrixxxk.

Plugin Support

Mahfuzur Rahman(woo-hc)

(@mahfuzurwp)

3 months ago

Hi @patrixxxk,

Thank you for sharing the details and the results of your testing so far!

Based on what you’ve described, it seems the issue might not solely be WooCommerce itself but potentially its interaction with other plugins, particularly WPML and possibly Elementor. To narrow this down further, could you test the following setup on your staging site?
1. Activate the Storefront theme.
2. Deactivate all plugins except WooCommerce.

This will help confirm if WooCommerce alone is causing the high memory usage or if the performance issues stem from interactions with other plugins.

If the performance improves significantly in this minimal setup, it’s worth gradually reactivating plugins (starting with WPML and Elementor) to identify any specific interactions causing the slowdown.

Another key area to review is caching:
? Ensure your product pages are being cached properly.
? If you’re using WPML with multi-currency or language-based cookies, these could interfere with caching. WPML may require specific configuration to work seamlessly with your caching system.

Let us know how the testing goes, feel free to share your results!

Thread Starter

patrixxxk

(@patrixxxk)

3 months ago

Hello @mahfuzurwp ,
There wasn’t a significant improvement with and without Storefront + Woocommecre, of course if I disable all the plugins except Woocommerce, there are some imprvements but nothing compared to the speed when I disable Woocommerce. You might be right, that there’s a high chance for a conflict between these 3 plugins (WPML, Woocommerce, Elementor).

I thought about the Db also, it has around 1,8-2,0 GB – which is huge compared to a site with 6k products and 30 plugins active, and it should be approx. 600MB.

(Plugins such as Wp-optimize were used, but it didnt made such a difference)

The only caching we have is through Cloudflare.

Is there a chance that one or more woocommerce tables are staying in loop or taking too long to respond / problem with them? Based on the fact that I have around 900-1000 queries per product visit.

Thanks!

Plugin Support

Mahfuzur Rahman(woo-hc)

(@mahfuzurwp)

3 months ago

Hi @patrixxxk,

Thanks for the details. The primary bottleneck appears to be database performance, likely due to its size, the number of products and orders, and complex queries from WPML and Elementor.

Here are our recommended next steps:

1. Database Optimization (Priority):

This is the most crucial area.

Identify and Optimize Large Tables: Use phpMyAdmin or a similar tool to identify your largest database tables, especially those with prefixes kvfoyo_wc_* (WooCommerce), kvfoyo_icl_* (WPML), and any Elementor-specific tables. Once identified, focus on optimizing these tables. Common optimization tasks include cleaning up unnecessary data (like old revisions or transients), optimizing indexes, and ensuring efficient queries.
kvfoyo_options Table: Pay special attention to the kvfoyo_options table, as it often stores significant amounts of transient data. Optimize this table by cleaning up expired transients.
Database Optimization Plugins (Use with Caution): Plugins like “WP-Optimize” or “Advanced Database Cleaner” can help automate some optimization tasks. Always back up your database before using these plugins.
Manual Database Optimization (Advanced): For more in-depth optimization, consider consulting a WordPress/WooCommerce developer who can analyze slow queries and implement more advanced optimizations.

2. WooCommerce Order Attributes:

Are you currently using WooCommerce order attributes to store additional product information? This can also increase loading speed!

3. Additional Plugins (Optional):

Index WP MySQL for Speed: This plugin can help optimize your database indexes for faster queries. You can install it from here: link to Index WP MySQL for Speed plugin
Fast Woo Order Lookup: This plugin helps speed up order searches on stores with many orders. You can install it from here: link to Fast Woo Order Lookup plugin

Please note: Installing any new plugin can potentially introduce conflicts. Always back up your site before adding a new plugin. We recommend trying these plugins after focusing on the core optimization steps above. Additionally, third-party plugins are out of our support scope, so please use them responsibly.

4. WPML and WooCommerce Integration:

WPML Troubleshooting: Review WPML’s performance documentation and settings, focusing on WooCommerce compatibility. Check for known compatibility issues between your WPML and WooCommerce versions. If tables like kvfoyo_icl_translate and kvfoyo_icl_translation_status are large, contact WPML support for optimization advice.
WPML String Translation: If you heavily use string translation, explore more efficient translation methods.

5. Elementor and WooCommerce Integration:

Elementor Templates and Widgets: Review your Elementor templates (especially product pages) and WooCommerce widget usage. Simplify complex templates and widget configurations.

6. Server Configuration:

While database optimization is the primary focus, increasing these PHP settings might provide some additional improvement, especially if you’re experiencing timeouts or memory exhaustion errors:

PHP Memory Limit: We recommend increasing this to at least 1GB. You can try setting this in your wp-config.php file using define('WP_MEMORY_LIMIT', '1G');. However, it’s essential to also confirm this setting with your hosting provider, as they may have server-level limits.
PHP Post Max Size: Increasing this is generally a good idea, especially if you handle large product images or imports. We suggest increasing this to 512MB or higher, depending on your needs. This is set in your server’s php.ini file (or sometimes via your hosting control panel).
PHP Time Limit: Increasing this can prevent timeouts during long-running processes like large imports or updates. A value of 600 seconds (10 minutes) or higher might be necessary. This is also set in your server’s php.ini file.
Important Note about PHP Settings: These changes are made on your server. You’ll likely need to contact your hosting provider for assistance in modifying php.ini or server-level settings. Simply adding the WP_MEMORY_LIMIT definition to wp-config.php might not be sufficient if your host has imposed lower limits.

7. WooCommerce Specifics:

High-Performance Order Storage (HPOS): With 3970 orders, enabling HPOS is highly recommended for improved order-related performance.

8. Enhanced Caching (Highly Recommended):

Redis Object Caching: Check if your hosting provider offers Redis. If so, install and configure the “Redis Object Cache” plugin. Redis significantly speeds up dynamic content by caching database query results in memory.

9. General Best Practices:

Keep WordPress, WooCommerce, plugins (especially WPML and Elementor), and your theme updated.
Maintain regular website and database backups.

I hope this helps, let us know how it goes!

Thread Starter

patrixxxk

(@patrixxxk)

3 months ago

Hello @mahfuzurwp,
Thanks for your fast reply.
My kvfoyo_options table has 10k rows and 25MB size, I think it’s reasonable.
Optimizing plugins were used, it helped with cleaning some transients and revisions, but it wasn’t much.
Sending screenshot of the biggest Db tables: https://snipboard.io/pzqkdJ.jpg
The icl translation status was successfully reduced previously before I contacted you, as we did everything with WPML on their end to clean up transitions etc…
The dbname_wc_* / dbname_woocommerce_* tables have around 20mb and smaller, the postmeta is incredible , more than 400MB! How do I know what files are transients or safe to clear in it?

2. WooCommerce Order Attributes:
It was in use, turned it off.
3. Additional Plugins (Optional):
While trying to optimize the site, I used the Index WP MySQL for Speed plugin , it didn’t help as much as it could due to Db not functioning as it should.
Fast Woo Order Lookup:? Is it necessary once I enabled High-Performance Order Storage (HPOS) ?

The PHP memory limit is increased to 1536M and the post max size to 512M;

THere is no change sadly, do you have an advice how can I manage and delete only the files / data from tables, that are 100% transients and old data? I tried it on the testing site many times, but I always ended up deleting data that we use.

All the plugins are up to date always. We tried Redis but it made the site slower.

Thanks!

Plugin Support

Zubair Zahid (woo-hc)

(@doublezed2)

3 months ago

Hello patrixxxk,

Thank you for your reply.

I appreciate the steps you have taken so far to troubleshoot the problem.

I have around 900-1000 queries per product visit

Could you share more information about these queries?
How did you find that out? Sharing a screenshot will be helpful.

I would not recommend manually removing or modifying the database data.
A few options are available under WooCommerce > System Status > Tools that will help you clear transients and old data.

At this point, there is not much information to diagnose the issue and find out the root cause.
You can share a video using https://quickforget.com if you like.
Seeing the dashboard will provide more clues into what is happening.

Looking forward to your response. ??

Viewing 7 replies - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

High Memory Usage and Slow Loading Times

Tags