About
FAQ
Location
Sponsors
News

Wiki

Presentations
Favorite Talks Schedule iCal export Submit a talk proposal



Users
Search Statistics
Register
Log in
top

By Matt S Trout (‎mst‎) from northwestengland.pm, dahut.pm, drinkers.pm, lgbt.pm
Date: Saturday, 29 November 2008 11:05
Duration: 40 minutes
Language:


The tale of building an app with a moderately complex DB schema and strict performance requirements on the single most complex query in the application, mixing and matching straightforward DBIx::Class ORM code to automate away the simple stuff, postgres views and triggers to create a transparent OODB-style setup using multiple table inheritance and to allow for complex queries to be optimised at the database level without the ORM getting in the way, and how we mixed the two together to create an app that not only meets the performance requirements set out at the start of the project but substantially exceeds them, and is still fast to add features to and easy to maintain.

Attended by: