MySQL supports subqueries since version 4.1 released 8 years ago. Due to their simplistic implementation and resulting poor performance, subqueries have been considered as practically unusable by many users.
MariaDB 5.3 changes this by implementing a consistently performing set of subquery processing techniques. These techniques make it possible to use subqueries in practice, and deliver performance improvements impossible to achieve by hand-optimized queries.
The talk provides a thorough overview of all types of subqueries covered by MariaDB 5.3 from the perspective of the DBA. Each type of subquery is explained with an example and sample performance measurement. We also give performance guidelines for manual control of the optimizer for backwards compatibility, or to solve tricky performance problems.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts