Why Your Database Queries Stink
Two percent of developers have any training in relational theory, sets, or structured query language but hey it has to be the $#^@ing databases fault things are slow!!!

Presented by:

davidmstokes

from Oracle -- MySQL Community Team

Dave Stokes is a MySQL Community Manager for Oracle. Previously he was the MySQL Certification Manager for MySQL AB and SUN. He has worked for companies ranging alphabetically from the American Heart Association to Xerox and work ranging from Anti-submarine warfare to web developer. And he really wonders how many people really, really read these conference biographies. Twitter = @ Stoker, blog = http://elephantdolphin.blogspot.com/

He lives in Texas and has the mandated pickup truck, hound dog, and Stetson hat.

Roughly 2% of developers have any training in Structured Query Language but are mystified why their database queries do not perform. They get stuck with the N+1 problem, denormalize their data, add object relational mappers that add layers of complexity, move to NoSQL system that do not scale or allow complex logical searchers, and end up frustrated. This sessions covers how to use Venn Diagrams to develop joins, how to efficiently think in sets, how to use the database to do the heavy lifting, the smart use of indexing, how query plans are developed, query re-write plugins, and more. If you use a relational database to store data and are not 100% confident in your queries you need to be in this session.

Date:
2016 November 11 - 14:00
Duration:
1 h
Room:
Room 3179
Conference:
Seattle GNU/Linux Conference 2016
Language:
Track:
Difficulty:
Easy

Happening at the same time:

  1. F as in Freedom: How We Talk When We Talk About Free Software
    2. Start Time:
    2016 November 11 14:00

    Room:
    Room 3178

  2. Uinversal Packages for Linux are a Myth - An Alternative - Open Build Server - The Linux Package Factory
    3. Start Time:
    2016 November 11 14:00

    Room:
    Room 3180

  3. Nom Nom: Consuming REST APIs
    4. Start Time:
    2016 November 11 14:00

    Room:
    Room 3183

  4. Many ways of Contributing to Open Source without Coding
    5. Start Time:
    2016 November 11 14:00

    Room:
    Room 3184