Dallas PHP User Group Meeting - February 2012
21 Feb 2012 at SoftLayer Offices

10 attended
Host: Chris Cornutt
Event Website:
Short URL: https://joind.in/e/dallasphp-feb2012 QR-Code (opens in new window)

This month we're going to have a special guest coming in from out of town - Paul Jones will be presenting his talk "Solving the N+1 Problem; or, A Stitch In Time Saves Nine". Here's the summary:

-----------

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. There is a solution in plain PHP that makes the number of queries constant to increase performance overall. The talk shows typical PHP code involving the N+1 problem, then shows how to solve the problem in plain PHP (that is, without a framework or ORM), and includes editorializing about the origins of the N+1 problem in the developer mindset.