Dear List,
I have a query (included below) which uses full text searching and it is fairly slow using BaseX 7.9 (5-8 seconds). I was wondering if there was a query cache implemented in BaseX? I ask because the GUI seems to keep a cache around because the same query goes from 5000ms to 204ms if I run it twice in the GUI.
The query looks like this:
declare variable $term as xs:string external; declare variable $col as xs:string external; <results>{subsequence(ft:mark(for $x in collection($col)//entry where $x//text()[. contains text {$term} using wildcards] order by fn:lower-case(fn:replace(($x//orth[1]/text())[1], '\p{P}|\d+','')) collation "?lang=ga" return $x), 1, 5000)}</results>
Thanks for any help you can provide.
Chris Yocum