Title: Extremely Poor Performance Last modified: June 6, 2023 --- # Extremely Poor Performance * Resolved [kanagency](https://wordpress.org/support/users/kanagency/) * (@kanagency) * [2 years, 11 months ago](https://wordpress.org/support/topic/extremely-poor-performance-2/) * After migrating to a new hosting provider, splitting the website into two nodes( web & database), we’re now experiencing extremely poor performance. * Our NewRelic monitoring suggests the main culprit of this performance bottleneck is the amount of calls to “WC_Product_Variable_Data_Store_CPT::read_price_data”. This averages roughly 50 calls to this function, but each time it’s taking about 150-200ms per call, so these in total is a huge issue. * The site info for the site is as below * ```wp-block-code ### wp-core ### version: 6.2.2 site_language: en_GB user_language: en_GB timezone: Europe/London permalink: /%postname% https_status: true multisite: false user_registration: 0 blog_public: 1 default_comment_status: undefined environment_type: production user_count: 4846 dotorg_communication: true ### wp-paths-sizes ### wordpress_path: /var/www/wadswick.co.uk wordpress_size: 177.17 MB (185778726 bytes) uploads_path: /var/www/wadswick.co.uk/wp-content/uploads uploads_size: 10.98 GB (11794012503 bytes) themes_path: /var/www/wadswick.co.uk/wp-content/themes themes_size: 29.99 MB (31450801 bytes) plugins_path: /var/www/wadswick.co.uk/wp-content/plugins plugins_size: 191.96 MB (201282466 bytes) database_size: 3.22 GB (3452469248 bytes) total_size: 14.59 GB (15664993744 bytes) ### wp-dropins (1) ### advanced-cache.php: true ### wp-active-theme ### name: Wadswick (wadswick) version: 1.3.9 author: Kan Agency / Alchemist Solutions author_website: (undefined) parent_theme: Flatsome (flatsome) theme_features: core-block-patterns, post-thumbnails, woocommerce, title-tag, automatic-feed-links, customize-selective-refresh-widgets, sensei, html5, menus, post-formats, wc-product-gallery-lightbox, widgets theme_path: /var/www/wadswick.co.uk/wp-content/themes/wadswick auto_update: Disabled ### wp-parent-theme ### name: Flatsome (flatsome) version: 3.17.1 author: UX-Themes author_website: https://uxthemes.com theme_path: /var/www/wadswick.co.uk/wp-content/themes/flatsome auto_update: Disabled ### wp-themes-inactive (1) ### Twenty Twenty-Three: version: 1.1, author: the WordPress team, Auto-updates enabled ### wp-plugins-active (43) ### Advanced Search Pro: version: 1.1, author: mndpsingh287, Auto-updates disabled AIOSEO - Image SEO: version: 1.1.7, author: All in One SEO Team, Auto-updates enabled AIOSEO - Redirects: version: 1.2.11, author: All in One SEO Team, Auto-updates enabled Akismet Anti-Spam: version: 5.1, author: Automattic, Auto-updates enabled All in One SEO Pro: version: 4.3.8, author: All in One SEO Team, Auto-updates enabled Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: version: 3.2, author: codewoogeek, Auto-updates disabled CAPTCHA 4WP: version: 7.2.1, author: WP White Security, Auto-updates disabled Classic Editor: version: 1.6.3, author: WordPress Contributors, Auto-updates enabled Classic Widgets: version: 0.3, author: WordPress Contributors, Auto-updates disabled Contact Form 7: version: 5.7.7, author: Takayuki Miyoshi, Auto-updates enabled Contact Form 7 Extension For Mailchimp: version: 0.5.68, author: Renzo Johnson, Auto-updates enabled Custom Sidebars: version: 3.36, author: WebFactory Ltd, Auto-updates disabled Discount Rules and Dynamic Pricing for WooCommerce: version: 7.9.1, author: Discount Team, Auto-updates enabled Facebook for WooCommerce: version: 3.0.23, author: Facebook, Auto-updates enabled GTM4WP: version: 1.16.2, author: Thomas Geiger, Auto-updates enabled Imagify: version: 2.1.1, author: Imagify – Optimize Images & Convert WebP, Auto-updates disabled Klarna Order Management for WooCommerce: version: 1.7.2, author: klarna, krokedil, Auto-updates enabled Klarna Payments for WooCommerce: version: 3.0.7, author: krokedil, klarna, automattic, Auto-updates enabled Mailchimp for WooCommerce: version: 2.8.3, author: Mailchimp, Auto-updates disabled Mailgun: version: 1.9.3, author: Mailgun, Auto-updates enabled Max Mega Menu: version: 3.2.2, author: megamenu.com, Auto-updates enabled Max Mega Menu - Pro Addon: version: 2.2.7, author: megamenu.com (latest version: 2.2.8), Auto-updates disabled Product Badges: version: 2.3.1, author: 99w (latest version: 2.3.2), Auto-updates disabled Redirection: version: 5.3.10, author: John Godley, Auto-updates disabled Variation Swatches for WooCommerce: version: 2.0.20, author: Emran Ahmed (latest version: 2.0.21), Auto-updates disabled Variation Swatches for WooCommerce - Pro: version: 2.0.20, author: Emran Ahmed (latest version: 2.0.21), Auto-updates disabled WooCommerce: version: 7.7.0, author: Automattic (latest version: 7.7.2), Auto-updates disabled WooCommerce Gift Cards: version: 1.15.5, author: WooCommerce (latest version: 1.16.1), Auto-updates disabled WooCommerce Opayo Payment Suite: version: 5.11.0, author: Andrew Benbow, Auto-updates disabled WooCommerce PayPal Payments: version: 2.0.4, author: WooCommerce (latest version: 2.0.5), Auto-updates disabled WooCommerce Pre-Orders: version: 1.5.30, author: WooCommerce (latest version: 2.0.2), Auto-updates disabled WooCommerce Product CSV Import Suite: version: 1.10.57, author: WooCommerce (latest version: 1.10.58), Auto-updates enabled WooCommerce Shipment Tracking: version: 2.3.1, author: WooCommerce, Auto-updates enabled WooCommerce Table Rate Shipping: version: 3.1.1, author: WooCommerce, Auto-updates disabled WooCommerce Tab Manager: version: 1.15.0, author: SkyVerge, Auto-updates disabled WP-Lister Pro for Amazon: version: 2.5.4, author: WP Lab, Auto-updates disabled WP All Export Pro: version: 1.6.6, author: Soflyy (latest version: 1.8.3), Auto-updates disabled WP All Import - WooCommerce Import Add-On Pro: version: 3.3.4, author: Soflyy, Auto-updates disabled WP All Import Pro: version: 4.8.0, author: Soflyy, Auto-updates disabled WP Super Cache: version: 1.9.4, author: Automattic, Auto-updates enabled YITH WooCommerce Cart Messages Premium: version: 1.30.0, author: YITH, Auto-updates disabled YITH WooCommerce Product Bundles Premium: version: 1.25.0, author: YITH, Auto-updates disabled YITH WooCommerce Wishlist: version: 3.21.0, author: YITH, Auto-updates enabled ### wp-media ### image_editor: WP_Image_Editor_Imagick imagick_module_version: 1691 imagemagick_version: ImageMagick 6.9.11-60 Q16 x86_64 2021-01-25 https://imagemagick.org imagick_version: 3.7.0 file_uploads: File uploads is turned off post_max_size: 20M upload_max_filesize: 20M max_effective_size: 20 MB max_file_uploads: 20 imagick_limits: imagick::RESOURCETYPE_AREA: 122 MB imagick::RESOURCETYPE_DISK: 1073741824 imagick::RESOURCETYPE_FILE: 768 imagick::RESOURCETYPE_MAP: 512 MB imagick::RESOURCETYPE_MEMORY: 256 MB imagick::RESOURCETYPE_THREAD: 1 imagick::RESOURCETYPE_TIME: 9.2233720368548E+18 imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVIF, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, H, HALD, HDR, HEIC, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMV, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV gd_version: not available ghostscript_version: 9.55.0 ### wp-server ### server_architecture: Linux 5.15.0-71-generic x86_64 httpd_software: nginx/1.18.0 php_version: 8.0.28 64bit php_sapi: fpm-fcgi max_input_variables: 5000 time_limit: 600 memory_limit: 256M admin_memory_limit: 2G max_input_time: 60 upload_max_filesize: 20M php_post_max_size: 20M curl_version: 7.81.0 OpenSSL/3.0.2 suhosin: false imagick_availability: true pretty_permalinks: true ### wp-database ### extension: mysqli server_version: 5.7.42 client_version: mysqlnd 8.0.28 max_allowed_packet: 1073741824 max_connections: 500 ### wp-constants ### WP_HOME: undefined WP_SITEURL: undefined WP_CONTENT_DIR: /var/www/wadswick.co.uk/wp-content WP_PLUGIN_DIR: /var/www/wadswick.co.uk/wp-content/plugins WP_MEMORY_LIMIT: 256M WP_MAX_MEMORY_LIMIT: 2G WP_DEBUG: false WP_DEBUG_DISPLAY: false WP_DEBUG_LOG: false SCRIPT_DEBUG: false WP_CACHE: true CONCATENATE_SCRIPTS: undefined COMPRESS_SCRIPTS: undefined COMPRESS_CSS: undefined WP_ENVIRONMENT_TYPE: Undefined DB_CHARSET: utf8 DB_COLLATE: undefined ### wp-filesystem ### wordpress: writable wp-content: writable uploads: writable plugins: writable themes: writable mu-plugins: writable ### aioseo (1) ### noindexed: Author Archives, Date Archives, Categories (category) ``` * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fextremely-poor-performance-2%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 2 replies - 1 through 2 (of 2 total) * Plugin Support [lionel.a11n](https://wordpress.org/support/users/lioneldaniel/) * (@lioneldaniel) * [2 years, 10 months ago](https://wordpress.org/support/topic/extremely-poor-performance-2/#post-16816726) * Hello [@kanagency](https://wordpress.org/support/users/kanagency/), * In general, performance is tightly connected to the plugin stack you are using and your server environment. We have some general advice for addressing performance issues on our blog (these tips range from general to technical – you already are monitoring your speed, for instance): [Ten Ways to Improve the Speed of Your WooCommerce Store](https://woocommerce.com/posts/ten-ways-to-speed-up-your-woocommerce-store/) * For your specific issue, it sounds like a plugin (or perhaps a theme feature, though Flatsome is a fairly popular theme so I doubt it) is initiating the numerous calls. * From the report you sent, I’d try disabling your “Discount Rules and Dynamic Pricing for WooCommerce” plugin and re-benchmarking your site. If that doesn’t work, I recommend a full conflict test to narrow down the issue – here’s a guide to conduct that test: [Conflict Testing Guide](https://docs.woocommerce.com/document/how-to-test-for-conflicts/) * You could try disabling plugins ad-hoc to test, but we find the thorough testing process to be a much faster way to resolve issues. * We look forward to hearing back from you, and if you have any further questions or details please include those in your reply. Thanks! * Plugin Support [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * (@gabrielfuentes) * [2 years, 10 months ago](https://wordpress.org/support/topic/extremely-poor-performance-2/#post-16833623) * As you haven’t responded in a while, I’m marking this as resolved. We’ll be here for you if/when you need us. Viewing 2 replies - 1 through 2 (of 2 total) The topic ‘Extremely Poor Performance’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) ## Tags * [performance](https://wordpress.org/support/topic-tag/performance/) * 2 replies * 3 participants * Last reply from: [Gabriel – a11n](https://wordpress.org/support/users/gabrielfuentes/) * Last activity: [2 years, 10 months ago](https://wordpress.org/support/topic/extremely-poor-performance-2/#post-16833623) * Status: resolved