Although ActiveRecord and the new Rails ORMs are optimized for general use cases with relational databases, most enterprise applications will not preform well enough using just the out-of-the-box functionality. Further, since often the ORMs do such a good job of hiding details when interfacing with the database, issues that might severely hinder scalability and performance are difficult to identify and are often ignored. In this talk, I will identify common database performance problems that arise when working with Rails and offer simple techniques and solutions to optimize them and the way your Rails app talks to the database. This talk will also include topics such as Creating good migrations that would make a DBA proud, Addressing common slow operations such as bulk importing records and querying across multiple tables, and Using actual database constraints (and keeping Rails happy).
Mahalo to ThinkTech Hawaii (thinktechhawaii.com) and Panopto (panopto.com) for their video recording services.