Very small effect after installing Scalability Pro

WP Intense Q & ACategory: Scalability ProVery small effect after installing Scalability Pro
Bogdan Dimitrov asked 1 month ago

Hello,

I have the following problem. I am making a WooCommerce site (https://lesnokupi.bg/) with about 30-35k products and until I started installing filters, wishlists, SEO plugins (Rank Math) etc. the site was going pretty well even without caching.

Category pages opened in less than 2 seconds, and so did product pages.

At the moment the speed dropped a lot, on average 5-6 seconds in the category pages, homepage - 7-9.

I bought your plugin, honestly there was some improvement, but things are quite slow. Even when I turn off all plugins except WooCommerce and the theme (flatsome), things are still slow. I thought that at least with all the plugins turned off and Scalabilty Pro turned on, things would work out, but it's still slow.

Ok, what i did:

1.Installed scaleability pro;

  1. I indexed the tables;
  2. I turned on most of the settings, but there were no noticeable results;

Can you help me solve the problem as described when I bought the plugin? What access data should I provide?

The site is https://lesnokupi.bg/

Information

Hosting - https://coolicehost.com/cloud-hosting.html (i am using the 8G plan)

Hosting Plan - LVE vCPU 4 x 3.1 - 4.3 Ghz

AMD Ryzen ™ Virtual Cores

8 GB Physical Memory

65 GB Enterprise NVMe Space

400 Entry Processes

Unmetered

Litespeed Server.

`

WordPress Environment

WordPress address (URL): https://lesnokupi.bg

Site address (URL): https://lesnokupi.bg

WC Version: 5.3.0

REST API Version: ✔ 5.3.0

WC Blocks Version: ✔ 4.9.1

Action Scheduler Version: ✔ 3.1.6

WC Admin Version: ✔ 2.2.6

Log Directory Writable: ✔

WP Version: 5.7.2

WP Multisite: –

WP Memory Limit: 512 MB

WP Debug Mode: ✔

WP Cron: ✔

Language: en_US

External object cache: –

Server Environment

Server Info: LiteSpeed

PHP Version: 7.4.16

PHP Post Max Size: 64 MB

PHP Time Limit: 160

PHP Max Input Vars: 10000

cURL Version: 7.71.0

OpenSSL/1.1.1d

SUHOSIN Installed: –

MySQL Version: 5.5.5-10.5.9-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: 5.3.0

WC Database Prefix: wpjg_

Total Database Size: 401.88MB

Database Data Size: 264.45MB

Database Index Size: 137.43MB

wpjg_woocommerce_sessions: Data: 0.08MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_order_itemmeta: Data: 0.04MB + Index: 0.02MB + Engine MyISAM

wpjg_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_actionscheduler_actions: Data: 32.87MB + Index: 9.91MB + Engine MyISAM

wpjg_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_actionscheduler_logs: Data: 21.85MB + Index: 14.35MB + Engine MyISAM

wpjg_ac_abandoned_cart_history_lite: Data: 0.11MB + Index: 0.00MB + Engine InnoDB

wpjg_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_aepc_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM

wpjg_dgwt_wcas_index: Data: 9.52MB + Index: 0.33MB + Engine InnoDB

wpjg_dgwt_wcas_invindex_doclist: Data: 23.55MB + Index: 12.44MB + Engine InnoDB

wpjg_dgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_dgwt_wcas_invindex_wordlist: Data: 2.52MB + Index: 2.52MB + Engine InnoDB

wpjg_dgwt_wcas_tax_index: Data: 0.11MB + Index: 0.05MB + Engine InnoDB

wpjg_dgwt_wcas_var_index: Data: 4.52MB + Index: 0.61MB + Engine InnoDB

wpjg_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wpjg_litespeed_crawler: Data: 1.52MB + Index: 1.67MB + Engine InnoDB

wpjg_litespeed_crawler_blacklist: Data: 0.44MB + Index: 0.58MB + Engine InnoDB

wpjg_litespeed_cssjs: Data: 0.06MB + Index: 0.03MB + Engine InnoDB

wpjg_litespeed_img_optm: Data: 10.52MB + Index: 8.00MB + Engine InnoDB

wpjg_litespeed_img_optming: Data: 0.14MB + Index: 0.05MB + Engine InnoDB

wpjg_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wpjg_mypos_pending_payments_schedule: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_options: Data: 8.15MB + Index: 0.89MB + Engine MyISAM

wpjg_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_pmxi_hash: Data: 1.40MB + Index: 1.50MB + Engine MyISAM

wpjg_pmxi_history: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

wpjg_pmxi_images: Data: 3.69MB + Index: 0.55MB + Engine MyISAM

wpjg_pmxi_imports: Data: 0.43MB + Index: 0.00MB + Engine MyISAM

wpjg_pmxi_posts: Data: 3.21MB + Index: 0.45MB + Engine MyISAM

wpjg_pmxi_templates: Data: 0.42MB + Index: 0.00MB + Engine MyISAM

wpjg_postmeta: Data: 108.17MB + Index: 58.52MB + Engine MyISAM

wpjg_posts: Data: 23.92MB + Index: 10.26MB + Engine MyISAM

wpjg_rank_math_analytics_objects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wpjg_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wpjg_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_scalability_pro_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_scalability_pro_profiling: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_termmeta: Data: 1.05MB + Index: 0.50MB + Engine MyISAM

wpjg_terms: Data: 0.35MB + Index: 0.76MB + Engine MyISAM

wpjg_term_relationships: Data: 3.59MB + Index: 10.35MB + Engine MyISAM

wpjg_term_taxonomy: Data: 0.30MB + Index: 0.84MB + Engine MyISAM

wpjg_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wpjg_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_usermeta: Data: 0.04MB + Index: 0.02MB + Engine MyISAM

wpjg_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_category_lookup: Data: 0.03MB + Index: 0.04MB + Engine MyISAM

wpjg_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_order_product_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_product_meta_lookup: Data: 1.24MB + Index: 1.80MB + Engine MyISAM

wpjg_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM

wpjg_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

wpjg_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB

wpjg_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB

wpjg_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

wpjg_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_wpmelon_advbedit_temp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

wpjg_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

wpjg_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB

Post Type Counts

attachment: 31337

blocks: 9

customize_changeset: 6

featured_item: 8

nav_menu_item: 1063

oembed_cache: 2

page: 17

post: 12

product: 11271

product_variation: 7909

revision: 117

shop_coupon: 2

shop_order: 10

wpcf7_contact_form: 3

xlwcty_thankyou: 1

yith_wcan_preset: 1

Security

Secure connection (HTTPS): ✔

Hide errors from visitors: ✔

Active Plugins (19)

Query Monitor: by John Blackbourn – 3.7.1

FiboSearch - AJAX Search for WooCommerce (Pro): by Damian Góra – 1.10.0

Classic Editor: by WordPress Contributors – 1.6

Contact Form 7: by Takayuki Miyoshi – 5.3

Flexible Shipping: by WP Desk – 4.5.0

LiteSpeed Cache: by LiteSpeed Technologies – 3.6.4

Loco Translate: by Tim Whitlock – 2.5.2

Woocommerce myPOS Checkout: by myPOS Europe LTD – 1.2.4

Premmerce Product Filter for WooCommerce: by premmerce – 3.4

Product Variations Swatches for WooCommerce: by VillaTheme – 1.0.1.11

Scalability Pro: by Dave Hilditch – 4.63

Rank Math SEO: by Rank Math – 1.0.63

TI WooCommerce Wishlist: by TemplateInvaders – 1.25.4

Checkout Field Editor for WooCommerce: by ThemeHigh – 1.4.8

Woo Discount Rules: by Flycart – 2.3.7

WooCommerce Stripe Gateway: by WooCommerce – 5.1.0

WooCommerce: by Automattic – 5.3.0

WP All Import Pro: by Soflyy – 4.6.5

WP All Import - WooCommerce Add-On Pro: by Soflyy – 3.2.5

Inactive Plugins (9)

Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 5.8.8

Media Cleaner: by Jordy Meow – 6.1.7

NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.14.1

Perfmatters: by forgemedia – 1.6.9

Safe SVG: by Daryll Doyle – 1.9.9

Stop Generating Unnecessary Thumbnails: by codexpert – 3.2.2

UberMenu 3 - The Ultimate WordPress Mega Menu: by Chris Mavricos

SevenSpark – 3.7.3

WooCommerce Advanced Bulk Edit: by George Iron – 4.6.2.3

Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.1.2

Dropin Plugins (1)

db.php: Query Monitor Database Class

Settings

API Enabled: –

Force SSL: –

Currency: BGN (лв.)

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: –

WC Pages

Shop base: #8 - /katalog/

Cart: #9 - /kolichka/

Checkout: #10 - /plashtane/

My account: #11 - /my-account/

Terms and conditions: #407255 - /garantsiq/

Theme

Name: Flatsome Child

Version: 3.0

Author URL:

Child Theme: ✔

Parent Theme Name: Flatsome

Parent Theme Version: 3.13.3

Parent Theme Author URL: http://www.uxthemes.com/

WooCommerce Support: ✔

Templates

Overrides: flatsome/woocommerce/archive-product.php

flatsome/woocommerce/cart/cart-empty.php

flatsome/woocommerce/cart/cart-shipping.php

flatsome/woocommerce/cart/cart.php

flatsome/woocommerce/checkout/form-checkout.php

flatsome/woocommerce/checkout/form-coupon.php

flatsome/woocommerce/checkout/terms.php

flatsome/woocommerce/checkout/thankyou.php

flatsome/woocommerce/content-product-cat.php

flatsome/woocommerce/content-product.php

flatsome/woocommerce/content-single-product.php

flatsome/woocommerce/content-widget-product.php

flatsome/woocommerce/global/breadcrumb.php

flatsome/woocommerce/global/quantity-input.php

flatsome/woocommerce/global/wrapper-end.php

flatsome/woocommerce/global/wrapper-start.php

flatsome/woocommerce/loop/loop-end.php

flatsome/woocommerce/loop/loop-start.php

flatsome/woocommerce/loop/pagination.php

flatsome/woocommerce/loop/result-count.php

flatsome/woocommerce/loop/sale-flash.php

flatsome/woocommerce/myaccount/form-login.php

flatsome/woocommerce/myaccount/navigation.php

flatsome/woocommerce/notices/error.php

flatsome/woocommerce/notices/notice.php

flatsome/woocommerce/notices/success.php

flatsome/woocommerce/product-searchform.php

flatsome/woocommerce/single-product/photoswipe.php

flatsome/woocommerce/single-product/price.php

flatsome/woocommerce/single-product/product-image.php

flatsome/woocommerce/single-product/product-thumbnails.php

flatsome/woocommerce/single-product/rating.php

flatsome/woocommerce/single-product/related.php

flatsome/woocommerce/single-product/review.php

flatsome/woocommerce/single-product/sale-flash.php

flatsome/woocommerce/single-product/share.php

flatsome/woocommerce/single-product/short-description.php

flatsome/woocommerce/single-product/tabs/tabs.php

flatsome/woocommerce/single-product/title.php

flatsome/woocommerce/single-product/up-sells.php

flatsome/woocommerce/single-product-reviews.php

flatsome/woocommerce/single-product.php

flatsome/woocommerce/content-product_cat.php

TI WooCommerce Wishlist Templates

Overrides: –

Action Scheduler

Canceled: 12

Oldest: 2021-05-14 10:01:41 +0000

Newest: 2021-05-14 10:01:41 +0000

Complete: 112,347

Oldest: 2021-04-16 20:30:37 +0000

Newest: 2021-05-17 20:30:15 +0000

Failed: 5,717

Oldest: 2021-03-02 12:33:07 +0000

Newest: 2021-05-17 20:30:04 +0000

Pending: 1

Oldest: 2021-05-21 10:00:00 +0000

Newest: 2021-05-21 10:00:00 +0000

Status report information

Generated at: 2021-05-17 20:30:22 +00:00

`

1 Answers
Dave Hilditch Staff answered 1 month ago

If you remove your filters, is your site fast? If so, it’s my plugin Faster Woo Widgets you need. Scalability Pro fixes slow queries, but the official Woo filters don’t really have slow queries, they just have 1000s of tiny queries that slow down the page and it wasn’t possible to fix those without writing my own filters plugin.

We use cookies

We use cookies for various things on our site, including our on-site chat bubble (if you use it), our comment forms (if you use them) and for session handling (if you log in).

Other than that, we use cookies to identify where traffic came from to help us understand which traffic turns into sales, we use a cookie for Google Analytics traffic analysis and we use a cookie to customise adverts for our own products we think you'll be interested in.

You can read more detail in our privacy policy page. Please click 'Accept' or 'Decline' to continue.