Chatter about SELECT N+1

Here is my little reference to conversations about the SELECT N+1 SQL Performance Anti-Pattern

http://blog.jooq.org/tag/object-relational-mapping/

http://stackoverflow.com/tags/select-n-plus-1/hot

http://stackoverflow.com/questions/97197/what-is-the-n1-selects-issue

http://use-the-index-luke.com/sql/join/nested-loops-join-n1-problem

http://thecuttingledge.com/?p=169
http://ayende.com/blog/1328/combating-the-select-n-1-problem-in-nhibernate
http://pramatr.wordpress.com/2009/02/05/sql-n-1-selects-explained/
http://docs.telerik.com/data-access/developers-guide/profiling-and-tuning/profiler-and-tuning-advisor/data-access-profiler-n-plus-one-problem
http://www.hibernatingrhinos.com/products/nhprof/learn/alert/selectnplusone
http://www.pbell.com/index.cfm/2006/9/17/Understanding-the-n1-query-problem
http://dotnet.dzone.com/news/select-n1-problem-%E2%80%93-how

http://java.dzone.com/articles/martin-fowler-orm-hate

http://learningviacode.blogspot.com/2012/07/the-n-1-select-problem-in-hibernate.html
http://learningviacode.blogspot.com/2012/08/fetch-join-for-collection.html
http://learningviacode.blogspot.com/2012/08/fetch-subselect.html
http://learningviacode.blogspot.sg/2012/08/batch-size-n.html

http://learningviacode.blogspot.in/2012/07/lazyextra.html