Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Recursive Query Throwdown in MySQL 8

Recursive Query Throwdown in MySQL 8

 27 April - 12:50 PM - 1:40 PM @ Ballroom C
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Developer
Topics:
MySQL
Optimization

Description

MySQL 8 introduces support for ANSI SQL recursive queries with common table expressions, a powerful method for working with recursive data references. Until now, MySQL application developers have had to use workarounds for hierarchical data relationships. It's time to write SQL queries in a more standardized way, and be compatible with other brands of SQL implementations. But as always, the bottom line is: how does it perform? This presentation will briefly describe how to use recursive queries, and then test the performance and scalability of those queries against other solutions for hierarchical queries.

Speakers

Bill Karwin's picture

Bill Karwin

Senior Database Architect, SchoolMessenger

Biography:

Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

Share this talk