full-text index available for attributes (is 'contains' applicable to attributes)?
Hi, I wonder if the full-text index is also available to attribute nodes: XQuery-Expression: for $i in //*:identifier[contains(@*:value,'nc1n2[C@H]')] return $i Query executed in 4106.57 ms. I also tried: for $i in //*:identifier[@*:value contains text 'nc1n2[C@H]'] return $i Query executed in 22350.34 ms. The full-test was activated using the console:
create index fulltext Index created in 562.23 ms. OPTIMIZE Database optimized in 27349.05 ms. SET FTINDEX Full-Text Index: ON
Thank you Patrick
I wonder if the full-text index is also available to attribute nodes:
Unfortunately it's not; as most queries we know are based on text nodes, we decided to skip attribute full-text requests. Note, however, that special characters, such as "[", are ignored anyway.
The full-test was activated using the console:
create index fulltext Index created in 562.23 ms. OPTIMIZE Database optimized in 27349.05 ms. SET FTINDEX Full-Text Index: ON
Just as a hint (the documentation is very sparse on that): optimize is only needed after database updates. If FTINDEX is set to ON, all subsequent database creations will include fulltext indexing. Christian
participants (2)
-
Christian Grün -
Patrick Schäfer