For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse at email@example.com
Download the OSCON Data Sponsor/Exhibitor Prospectus
For information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
To stay abreast of convention news and announcements, please sign up for the OSCON email bulletin (login required)
View a complete list of OSCON contacts
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 is the author of Sphinx, an open-source full-text search engine designed especially for indexing databases.
Adam received his start in software/databases at MySQL in 2004. In 2011, he heard about a great search server called Sphinx and decided it would be foolish not get behind such a great technology. He now serves as the Director of sales at Sphinx Search and looks forward everyday, to spreading ‘the word’ about the riddle that is Sphinx.