[Exist-open] Questions about performances

[Jean-Christophe K. <jc...@bl...>]

Hello,

Here are a few queries and their performances

I run the folowing queries on a database with 2000 event records on my=20
Centrino (1,3 GHz) with windows

1)

/document
[meta/state=3D'-1']

returns me 2 results in 150ms

2)

/document
[meta/state=3D'-1']
[meta/doctype=3D'event']

returns me 2 results in 170ms

3)

/document
[meta/state=3D'-1']
[meta/doctype=3D'event']
[starts-with(meta/dtstart,'2006')or(starts-with(meta/dtstart,'2007'))or(s=
tarts-with(meta/dtstart,'2008'))]

returns me 2 results in 3225 ms

4)

/document
[meta/state=3D'-1']
[meta/doctype=3D'event']
[match-any(meta/dtstart,'200[6|7|8]-..-..T')]

returns me 2 results in 631 ms

Why 3 is so slow ? I'm just comparing the value of 2 meta/dtstart with=20
2006, 2007, ...

In comparison, why 4 is a lot faster ?

To conclude, why even 4 (where I just added=20
[match-any(meta/dtstart,'200[6|7|8]-..-..T')]) needs 460 ms more of 2)=20
to complete ?

Thanks for the great product :-)

Jean-Christophe
--=20

BlueXML
Jean-Christophe Kermagoret
Directeur associ=E9
jc...@bl...