Re: [Exist-open] Simple query, slow reponse

[Andrew H. C. S. <And...@uw...>]

Incidentally,
for $a in (1 to 1000)
return update insert=20
<property><name>{$a}</name><value>{$a}</value></property> into=20
//GroupingList
takes 16s
second time takes 44s
third time takes 73s
fourth time takes 106s
//GroupingList/property[name =3D "99"]
then takes 4s
for $a in //GroupingList/property
return $a[name=3D"99"]
takes only 0.3s
and
for $a in /GroupingList/property
return update delete $a
takes 99s

Sorry the timings are being pasted by other processes on the server but=20
as you can see the "[" function/code doesn't scale well but
the "for return" is very fast and delete is quicker than insert in this=20
case.

Andrew Hart CEMS Staff wrote:
>
> P.S inserting only 4000=20
> <property><name></name><value></value></property> items to save time.
>
>  =20
>


This email has been independently scanned for viruses and any virus softw=
are has been removed using McAfee anti-virus software