January 10, 2012 6:00 PM. 25 attended.

Solving the N+1 Problem; or, A Stitch In Time Saves Nine

ESpaces (map)

Selected By: Ryan Weaver

Hey guys! We've got a great talk this month as the great (and finally our very own) Paul M Jones talks about the "N+1" problem when working with databases:

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.

If you haven't met Paul yet, he's one of the top names in the world of PHP - now's a great time to hear him talk and meet him afterwards.

Paul is an internationally recognized PHP expert who has worked as everything from junior developer to VP of Engineering in all kinds of organizations (corporate, military, non-profit, educational, medical, and others). Paul's latest open-source project is the Aura project for PHP. Among his other accomplishments, Paul is the lead developer of the Solar Framework, the creator of the Savant template system, has authored a series of authoritative benchmarks on dynamic framework performance, and was a founding contributor to the Zend Framework (the DB, DB_Table, and View components). In a previous career, Paul was an intelligence operations specialist for the US Air Force, and enjoys punching 7.62mm holes at 400 meters.

See you guys there!

  • Luke Stokes
    Luke Stokes

    So sorry to miss this. I'm sure it's going to be really good. I had something scheduled a month ago. Paul, I hope you make your slides and notes available.

    Posted January 10 at 9:21 AM
  • Paul M. Jones
    Paul M. Jones

    The Aura website is http, not https: http://auraphp.github.com

    Posted January 10 at 9:22 AM
  • Paul M. Jones
    Paul M. Jones

    Luke: yes, that is the plan.

    Posted January 10 at 9:23 AM
  • You must be a member to post a comment. Join or login.

25 attended
5.00 5.0010 (10 ratings)

Offer a perk for our members and get exposure.

Offer a perk →
People in this
Meetup are also in:

Log in

Not registered with us yet?

Sign up

Meetup members, Log in

or
By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service