Could you point me to the JIRA tasks, I would be interesting in seeing
what the ultimate solution looks like?
JIRA is searchable. Look for things marked as 'query-hql' as the
component... The basic idea is to drop the collection-valued fetches.
The thing that confuses me is that distinct generally doesn't come for
free (generally resuls in a sort by the DB). If the result set is
going to be the same anyway, isn't there an advantage to excluding the
distinct clause, or is it simply not possible to determine which
queries will benefit from it and which won't?
It depends on the quite a few things like the particular database, db
server options, the width and depth of the selected dataset, the JDBC
driver, the network, etc. All-in-all, it is not feasible to detect when
to do it and when not to do it.
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
