Are lots of queries faster in MySql than a big JOIN?

(written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at: lawrence@krubner.com, or follow me on Twitter.

I find this hard to believe, but I’ve now read it in several places. Some people seem to think that lots of queries are faster than big JOINs, in MySql.

Post external references

  1. 1
    http://www.selikoff.net/2008/12/10/memo-avoid-nested-queries-in-mysql-at-all-costs/
Source