SQL N + 1 Query Problem

One complex SQL query is typically faster than an equivalent set of simple SQL queries due to the inherent overhead in all SQL queries.  This is referred to as the SQL N + 1 query problem.