Presales Q

D. Demetre asked 10 months ago

Hello, question concerning Scalability Pro.

The plugin seems to be aimed mostly at owners of Ecommerce sites. My site is a news content site with around 6,000 posts. After moving to a Vultr server with MySql 8, I noticed a slowdown in the admin panel. (the site is loading quite fast for external users viewing content).Installing Query Monitor, clicking edit for a typical post is taking 14.9 seconds. It looks to be core WP problem, with a query to Postmeta table taking 14.5 seconds.

My question is, would Scalability Pro be useful for eliminating the slowdown problem I am having, and for future scalability of the site?

1 Answers
Dave Hilditch Staff answered 9 months ago

Yes – there are many plugins that query against wp_postmeta and Scalability Pro optimises these queries by adding indexes that those custom queries then use.

Even with only 6,000 posts, wp_postmeta could be 300,000 rows or more. If SQL queries do not use an index against a table of that size it means that the queries need to check every single row. Checking 300,000 rows is slow and is where your 14 seconds is coming from.

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.