Hi all,
I'm trying to implement an auto-complete dropdown which searches a range
index with approx 3 million values. The plan is to run a search after
the user has typed at least 3 characters, and match that string anywhere
in the values. The query I'm using is:
(: example search for authors with whi anywhere in their name :)
let $q := 'whi'
return cts:element-value-match(xs:QName("Author"), concat("*", $q, "*"),
("ascending", "case-insensitive"))
This currently takes 10 seconds.
I'm hoping that adding some extra indexes will help the performance.
Currently I have the following enabled:
- Word searches
- Fast phrase searches
- Fast element word searches
- Fast element trailing wildcard searches
- Three character searches
I'm struggling to work out the practical uses of the different indexes -
they all sound the same and the documentation just causes more confusion
:(
Can anyone explain what indexes would improve my query, or is there a
better way of writing the query itself?
Thanks a lot,
Rob
_______________________________________________
General mailing list
[email protected]
http://xqzone.com/mailman/listinfo/general
