Unlock your potential with a Pro Membership
Here is where you propel your career forward. Come join us today. Learn more.
Test Slow Approach – Part 1
Lab: Advanced SQL – Get Posts Grouped by Terms
Video Runtime: 17:27
Let’s run the slower approach and test what happens. We want to see how many times the database is hit as well as what SQL queries are processed. In this episode, you’ll explore how the terms, taxonomy, and posts are related by looking at the database tables and their schema. Then you’ll discover the SQL queries when running get_terms().
This episode is Part 1 of a two-part testing exercise. There’s much to cover and learn as you deep dive into database tables, relational information, SQL queries, get_terms(), and WP_Query.
Don’t repeat yourself. Don’t repeat yourself. Don’t repeat yourself.
Episodes
Total Lab Runtime: 02:46:48
- 1 Lab Introductionfree 14:27
- 2 Slow Approach Overviewpro 12:11
- 3 Test Slow Approach - Part 1pro 17:27
- 4 Test Slow Approach - Part 2pro 21:07
- 5 Relational Typespro 23:20
- 6 Types of Joinspro 09:30
- 7 Joining Metadatapro 12:37
- 8 Joining Posts to Termspro 20:32
- 9 Grouping Datasetspro 08:32
- 10 WordPress SQL Handler $wpdbpro 11:01
- 11 Deeper Dive into $wpdb->get_resultspro 05:54
- 12 Run Fast Approach & Compare Resultspro 10:10
