Okay... I found the problem and fixed it. The fix will be on review board in a little while.
On Thu, Jan 14, 2010 at 12:33 AM, aw <[email protected]> wrote: > I enabled SQL logging recently, and started looking at the generated > SQL from Mapper. I was surprised to see that "select DISTINCT" was > generally being done for queries when it is not necessary. Is that > really necessary? > > For example: > Team.findAll(OrderBy(Team.name, Ascending)) > translated to: > SELECT DISTINCT team.code, team.name, team.id FROM team ORDER > BY name ASC > > Queries should perform better without a redundant DISTINCT operation. > > I must say that I am surprised to see the DISTINCT added when a > Distinct object/class exists -- I would have expected that I would > have needed to use the Distinct object/class in order to generate the > DISTINCT keyword. > > -- > You received this message because you are subscribed to the Google Groups > "Lift" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<liftweb%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/liftweb?hl=en. > > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 Follow me: http://twitter.com/dpp Surf the harmonics--
You received this message because you are subscribed to the Google Groups "Lift" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.
