Taking ActiveRecord to the Next Level

Blythe Dunham (Spongecell)
Average rating: ****.
(4.00, 2 ratings)

While the Ruby on Rails is great to get you up and running in minutes, performance modifications are necessary to scale to the next level. By leveraging several simple techniques, one can expand ActiveRecord, the Rails implementation of object-relational mapping (ORM), to realize vast improvements in the database layer.

For the first part of the talk, I will discuss how and when one would want to use MySql features which are not included with the default ActiveRecord implementation. While many of these features are very simple to add by either getting your hands wet with SQL or by using an ActiveRecord extension plugin, and they can drastically improve the code quality as well as jump-start the ORM performance of a rails application.

  • ON DUPLICATE UPDATE
  • IGNORE
  • INSERT SELECT
  • INSERT (multiple values)
  • UNION
  • USING (specifying indices)

Other general techniques and tricks to enhance and reduce the number of queries generated by Rails will be discussed as well as any existing related rails gems and plugins one can leverage.

  • selecting specific columns
  • using eager load
  • reading from a replica

Attendees should have knowledge of basic Ruby on Rails, ActiveRecord, and SQL.

Photo of Blythe Dunham

Blythe Dunham

Spongecell

Blythe Dunham is co-founder and architect at Spongecell, LLC where she has been working with MySQL and Ruby on Rails since 2005.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

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

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) 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

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.