Sponsors

  • 10gen
  • DataStax, Inc.
  • Dell
  • Google
  • Lexis Nexis
  • Oracle
  • VMware
  • Percona

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Data Sponsor/Exhibitor Prospectus

Media Partner Opportunities

For information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

OSCON Bulletin

To stay abreast of convention news and announcements, please sign up for the OSCON email bulletin (login required)

Contact Us

View a complete list of OSCON contacts

Network
Join Attendee Network
 

Why Know Algorithms

Andrew Aksyonoff (Sphinx Technologies), Adam Rice (Sphinx Search)
11:30am Tuesday, 07/26/2011
Data: Relational
 Location: C121/122
Tags: algorithms, databases, b-tree, dba_dude
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.

People planning to attend this session also want to see:

Andrew Aksyonoff

Sphinx Technologies

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

Photo of Adam Rice

Adam Rice

Sphinx Search

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.