Re: [Exist-open] XQuery help - to make a query run faster

[Pierrick B. <pie...@cu...>]

Hi,

KevinBenson a =E9crit :

> I should note a very early eXist 1.0b2 I have can do this query fairly=20
> fast compared to the last several exist releases, but it is much much=20
> older eXist.

This is probably due to the fact that older versions of eXist used the=20
fulltext index to optimize general comparisons.

> *One final note the very last constraint "and ($x/@status =3D 'active')

This is a general comparison :-)

> I am thinking it could just be my lack of xquery/xpath knowledge not=20
> being able to make it faster.  Any ideas on how to make this query=20
> faster?

Sure, define range (or QName) indexes on @xsi:type, vr:title... and use=20
general comparison operators - not full text ones - to actually use them.

Cheers,

--=20
Pierrick Brihaye, informaticien
Service r=E9gional de l'Inventaire / DRAC Bretagne
mailto:pie...@cu... / t=E9l : +33 (0)2 99 29 67 78
Avez-vous lu http://usenet-fr.news.eu.org/fr-chartes/rfc1855.html ?