ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kris Jenkins <krisajenk...@yahoo.co.uk>
Subject Re: What is N+1
Date Wed, 09 Feb 2005 11:52:19 GMT
friendVU admin wrote:

> What is n+1?
> .V


n++!   :-P

It's when each child object in a complex query has to be selected 
seperately.  If 'parent' has 10 'children', you end up with 10+1 select 
statements being issued.  See the developer's guide under 'Avoiding N+1 
selects' for the full lowdown.  Version 2.0.9 comes with new groupBy 
goodness to banish the N+1 problem.

Kris

-- 
Kris Jenkins
Email:  kris@jenkster.com
Blog:   http://cafe.jenkster.com/
Wiki:   http://wiki.jenkster.com/



Mime
View raw message