Sessions at OSCON 2012 about Databases on Thursday 19th July

View as grid

• A Stitch In Time Saves Nine: Solving the N+1 Problem

  by Paul Jones

  When dealing with databases, developers frequently run into the N+1 problem, in which they populate domain objects via queries in loops. This causes terrible performance drags. The talk shows how to solve the N+1 problem in plain PHP as well as Postgres. It concludes with a way of automating the PHP side, and includes editorializing about the origins of the N+1 problem in the developer mindset.

  • Databases
  • N+1
  • PHP
  • PostgreSQL

  At 11:30am to 12:10pm, Thursday 19th July

  In E144, Oregon Convention Center

• What every web developer should know about database optimization

  by Steve Meyers

  Most developers are developers, not DBAs, yet many smaller companies have inadequate database experience in-house. This is largely because databases like MySQL and PostgreSQL don't necessarily require a full-time DBA to administer. It's become more important for developers at smaller companies to have some basic knowledge of how to keep their database happy.

  • Databases

  At 5:00pm to 5:40pm, Thursday 19th July

  In E144, Oregon Convention Center