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

`