On Wed, 2010-04-28 at 14:38 -0700, Josh Berkus wrote:
> > I think the join removal feature is of critical importance, much more so
> > than many of the above items.
>
> I just don't have any figures on actual performance benefit from this,
> which will be the *first* thing a reporter asks.
"Orders of magnitude" saving. It's not *faster* it just doesn't do the
work at all any more.
> > I might describe it like in *one* of these ways
> >
> > * Automatic join removal to optimise complex SQL generated by OR mapping
> >
> > * Major new optimizations for complex automatically generated SQL
>
> How about
>
> * Optimization of ORM-generated queries through automatic join removal
Good. All 3 do it for me, but I think I'm too close to judge.
--
Simon Riggs www.2ndQuadrant.com