• Skip to primary navigation
  • Skip to 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 Manager Partnerships at Yoast.

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

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.

Top Posts

  • WordPress Plugin Names Word Cloud
  • Building a Multilingual Website? These are the Questions to Ask.
  • Adding Pages to Your RSS Feed in WordPress
  • It's Time to Stop Kicking the BuddyPress Puppy
  • Now on WordPress: The oldest continuously published magazine in the English language
  • Yes, You Can: Plugin Auto-Updates From Github
  • Upgrade your client services with documentation

Like us, why don’t you?!

Like us, why don’t you?!

Recent Comments

  • Floris Lof on Building a Multilingual Website? These are the Questions to Ask.
  • Caner on Building a Multilingual Website? These are the Questions to Ask.
  • Pieter on WordPress.com, Jetpack and How It’s All Changing, Maybe?
  • Michael on WordPress.com, Jetpack and How It’s All Changing, Maybe?
  • Goob on WordPress.com, Jetpack and How It’s All Changing, Maybe?
Copyright © 2012 – 2019 WP Realm
Have you seen how fast Servebolt serves this site?