Queries at least 5 times faster, maybe 10!

  • Thank you!

    Meta queries on a site with over 200,000 posts are now very fast.

    I used WP-CLI and ran:

    wp index-mysql enable --all

    Database size increased from 1.5 GB to almost 7 GB, but I don’t think that matters in my case.

    Very cool plugin!

Viewing 1 replies (of 1 total)
  • Plugin Author OllieJones

    (@olliejones)

    I’m happy to hear it works for you! Adding keys definitely makes the database take more SSD / HDD space and use more buffer pool space in MySQL / MariaDb. But drive space and RAM are really cheap compared to the time of web site visitors!

Viewing 1 replies (of 1 total)
  • The topic ‘Queries at least 5 times faster, maybe 10!’ is closed to new replies.