Group by

Although the spec includes a "Group by" example we have found that such an
xquery performs very poorly. The reason for this is that the number of
comparisons explode as it behaves quadratically. 
Since there is a sort by expression why not a group by as well - it would
also make mapping to SQL a little easier.
At the moment we have implemented group by as a function - with enormous
performance gains

Regards,
Eddie 

Received on Thursday, 31 October 2002 04:36:44 UTC