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 lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.