• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

WP Realm

WordPress news, community news, reviews and more from all over the world

  • News
  • Reviews
  • Tutorials
  • eCommerce
  • About
  • Contact

Scott Taylor on Understanding MySQL in WordPress

10 February 2013 by Remkus de Vries 2 Comments

Scott Taylor posted a very detailed write up about understanding MySQL in WordPress. Something I personally think every single WordPress developer – be it plugins or themes – ought to have a deep understanding of. Not just know of it’s existence. In Scott’s words:

You would be surprised how many people I have interviewed for a job that think their PHP chops are great, but their MySQL, not so much. Many great WordPress developers I know have said the same thing. Not cool. Bad SQL can bring down your site! Forget crazy scaling challenges, basic WP Query usage can bring your site down if you aren’t careful. WordPress is a framework that provides you with a lot out of the box, but you are still going to end up writing a bunch of your own PHP to make it work the way you want. The same should be true, but often isn’t, for SQL queries.


I have to agree with Scott, it’s not just about understanding WordPress through its functions, filters and hooks, but to get the most out of it wonderful piece of software, you need to go deeper.

So be honest, how are good are your MySQL skills?

ShareTweet

Filed Under: Miscellaneous Tagged With: MySQL

About Remkus de Vries

Avid and heavy WordPress user since 2005, so effectively a WordPress oldtimer. Started as developer and agency owner, now works as Head of Partner & Customer relationships at Servebolt.

Co-founded WordCamp Europe in 2012, and WordCamp Netherlands back in 2009.

Principal owner of WP Realm.

Reader Interactions

Comments

  1. Ryan Hellyer says

    13 February 2013 at 14:02

    How good are my MySQL skills? Not very.

    Reply
  2. Mikel King says

    4 April 2014 at 18:00

    I couldn’t agree more… Sure your site may be ok at the hobbyist level but when you start hitting any real load it all falls apart.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

SUBSCRIBE

Our posts to your inbox. It's a wonderful thing.

Recent Comments

  • Remkus de Vries on Building a Multilingual Website? These are the Questions to Ask.
  • Tuba on Building a Multilingual Website? These are the Questions to Ask.
  • Remkus de Vries on Adding Pages to Your RSS Feed in WordPress
  • Kris on Adding Pages to Your RSS Feed in WordPress
  • WPML, qTranslate eller Polylang: hvilken du skal velge og hvorfor? (2020) - My Blog on Building a Multilingual Website? These are the Questions to Ask.
Copyright © 2012 – 2022 WP Realm
Have you seen how fast Servebolt serves this site?