Re: [Exist-open] Slow "group-by"-like query on large data set

[Alessandro V. <av...@sc...>]

Wolfgang,


Wolfgang Meier-2 wrote:
> 
> let $grouped :=
> 	for $person in /person
> 	group $person as $person-group by $person/family as $family
> 	return
> 		(: tell eXist not to use a structural index :)
> 		let $totalIncome := sum((#exist:no-index#) { $person-group/income })
> 		(: alternative workaround which has nearly the same effect as 
> exist:no-index :)
> 		(: let $totalIncome := sum(util:expand($person-group)/income) :)
> 		return
> 			<family>
> 				{$family}
> 				<income>{$totalIncome}</income>
> 			</family>
> for $family in $grouped
> order by xs:int($family/income)
> return
> 	<tr>
> 		<td>{$family/family/text()}</td>
> 		<td>{$family/income/text()}</td>
> 	</tr>
> 

Thank you! This works great.

Alex

-----
Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
Personal Blog: http://avernet.blogspot.com/
Twitter - http://twitter.com/avernet
-- 
View this message in context: http://www.nabble.com/Slow-%22group-by%22-like-query-on-large-data-set-tp19643245p19659243.html
Sent from the exist-open mailing list archive at Nabble.com.