•  

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

A session at Nomad PHP Europe - January 2014

Thursday 23rd January, 2014

8:00pm to 9:00pm

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

About the speaker

This person is speaking at this event.
pmjones

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, and the creator of the Savant template system. He 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). He was also a member of the Zend PHP 5.3 Certification education advisory board. In a previous career, Paul was an intelligence operations specialist for the US Air Force, and enjoys putting .308 holes in targets at 400 yards.

Sign in to add slides, notes or videos to this session

Tell your friends!

When

Time 8:00pm9:00pm AMT

Date Thu 23rd January 2014

Short URL

lanyrd.com/sctxdc

Official session page

nomadphp.com/…anuary-2014-eu/

View the schedule

Share

See something wrong?

Report an issue with this session