Why Know Algorithms

Data: Relational
Location: C121/122
Average rating: *....
(1.90, 10 ratings)

This session will discuss a few very generic SQL internals at a very high level perspective and a very high pace. You’ll learn how rows are stored, how indexes work, what’s B-tree and why’s everyone using it, how queries get executed inside the server, when can they get slow and why the optimizer isn’t your friend sometimes, and how to make those queries fast again.

Andrew Aksyonoff

Sphinx Technologies

Andrew is the author of Sphinx, an open-source full-text search engine designed especially for indexing databases.

Photo of Richard Kelm

Richard Kelm

Sphinx Search

From humble beginnings focused on storing and maintaining data in MySQL. Richard, matriculated to Sphinx Search where he’s learned the value of synthesizing mountains of text and attributes into meaning for individuals to consume.