Congratulations for this useful plugin, you fixed my database speed issues

  • Resolved malakontask

    (@malakontask)


    2 years, 4 months ago

    Hi,

    Congratulations for this useful plugin, you fixed my database speed issues..
    Are there any other steps to make my database faster ?
    I uploaded 5min monitor of my website with id “dY8YQJZq” to check if you can help me fix more speed issues..

    Check also my bigger tables on the screenshot below please.
    https://prnt.sc/26k6wpg

    Kind regards
    Kostas

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author OllieJones

    (@olliejones)

    2 years, 4 months ago

    Thanks for the kind words. And, thanks for telling me about your success on your large store. It’s good to know this worked scaled up to 7+ megarows in wp_postmeta.

    Your uploaded monitor doesn’t suggest anything dramatic about other optimizations. But, for what it’s worth, you ran the monitor before you added the plugin’s high-performance keys. You might try another monitor after enabling the keys.

    lkraav

    (@lkraav)

    2 years, 4 months ago

    > It’s good to know this worked scaled up to 7+ megarows in wp_postmeta.

    We have 10M rows in wp_postmeta, and after getting the wp_postmeta performance index built y-day (had to reconfigure tmpdir off /tmp, which at 2.6G free still ran out of space),

    query speed increase was absolutely mind-blowing.

    We had 20-30-40s queries go down to 1s and less (WC orders, subscriptions etc)

    lkraav

    (@lkraav)

    2 years, 4 months ago

    I’m most confused on, why isn’t this in WooCommerce core yet.

    I’m going to open that discussion with WC team.

    Thread Starter malakontask

    (@malakontask)

    2 years, 4 months ago

    > I’m most confused on, why isn’t this in WooCommerce core yet.
    I’m confused too why this isn’t in Woocommerce core..
    Please ask them and update this post.

    > You might try another monitor after enabling the keys.
    Please check the new 10min monitor with the keys enabled.. (id dY8YQJZq)

    PS. i also enabled redis object cache after new keys.

    Thank you!

    • This reply was modified 2 years, 4 months ago by malakontask.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Congratulations for this useful plugin, you fixed my database speed issues’ is closed to new replies.