From: Alessandro V. <av...@sc...> - 2007-05-31 15:22:44
|
Andrew Hart CEMS Staff wrote: > > Especially when > > let $b := > count( > for $a in /GroupingList/property > return $a[name = '99'] > ) > return $b > > takes 281ms but > > /GroupingList/property[name = '99'] > > takes 2209ms. > This would mean rewriting the query to: let $b := count( for $a in /root/property return $a[name = 'foo'] ) return $b But this query takes more than 5 minutes (I have a query-timeout setup at 5 minutes). While the original query took around 1 second. So at least in this case, this rewrite does not help. Alex -- Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise http://www.orbeon.com/ -- View this message in context: http://www.nabble.com/Simple-query%2C-slow-reponse-tf3842858.html#a10896113 Sent from the exist-open mailing list archive at Nabble.com. |