What you need to know about WordPress databases

Uncover what makes some database queries slow while others run super fast. In this advanced developer session, Gabor Javorszky provides direction on how to optimize and organize your data and a clear explanation for why, sometimes, it makes more sense to use your own custom database tables instead of sticking to the data schema provided by WordPress core.

Become a Member

Already a member? Please sign in.

SKU: N/A Category:

Description

Each of our sessions are digitally broadcast live and feature world-class speakers. Each presentation typically has 30-40 minutes set aside for instruction followed by another 15 minutes or so for Questions & Answers at the end.


About This Session

Imagine having a slow website. You’ve implemented caching to the best of your ability, and that helped, but you can’t cut the database out completely on this site. Maybe you’re running an ecommerce shop and your shop has to process an order for every customer. Maybe you’re running a membership site and a large percentage of your visitors need to view content unique to their own browsing experience. There could be a variety of reasons that you still need to query the database as visitors browse the site.

If we cannot eliminate the database completely, how can we speed it up?

Before we can tackle how to make things faster, we need to spend a bit of time understanding why they’re so slow in the first place. A partial explanation for this is the simple fact that WordPress has been around for a long time. As you likely know already, backwards compatibility is paramount for a project of this scale. What this means, for us, is that we need to live with some decisions that were made a decade or more ago. Some of these decisions involve the database, and some of those can cause major headaches and slow sites. We’ll shed some light on a few of these bottlenecks and show you what to do about them.

Follow along as Gabor takes us through the current structure of the tables, their bottlenecks, and some quick fixes. He’ll teach you some of the theory and practice behind indexes in MySQL – how they work and how to use them – and then provide practical examples and tips on building data structures that allow you to scale effortlessly.

What you’ll learn

  • What a database index is
  • How database indexes work
  • Why some WordPress tables are bad for your data
  • What to consider before organizing your data
  • When to use core tables, post types, and meta
  • When and why to use custom database tables
  • Resources for better database design and performance

 


About Gabor Javorszky

Gabor Javorszky has been doing commercial web development using WordPress since 2011. During that time he’s seen all sorts of clients from boutique architecture studios to global brands, from tiny sites to ones where the strongest servers were struggling to keep up. He slowly found out that his heart is in back-end development and figuring out solutions for scaling issues and generally developed an appreciation for fast response time. Nowadays he spends his time with his face stuck on staring at charts and data from monitoring software. And helping folks in various forms with their sites.

Follow Gabor on Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.