Hello Anand, please make sure to send all help requests to the mailing list - this way all users can benefit from it. At the moment I don't see much potential to improve your query (but I am no expert on full-text search, so this is merely my opinion). The "all words" keywords are unnecessary, as you only use one word. The most important consideration is if the Full-Text Index is actually applied to your query. You can check by analyzing the query info, something like "Applying full-text index" should be found. You can find more information at https://docs.basex.org/wiki/Full-Text#Index_Processing So, have you created a Full-Text Index? This should definitely be your first step, as this will certainly boost your performance. You should also check the query info as suggested and also take a look at the optimized query plan given by the compiler, as this can point you to some bottlenecks in your query. Cheers, Dirk On 28/12/13 10:25, Anand Chiney wrote:

Dear Dirk,

How are you ?

Need some help on using ft:search() in following condition, if applicable.

Following is the structure of XML file. Around 6 GB of articles in 3 XML DBs

---

<Docs> <Doc> <Title name="Speed of Light" author="John Best" /> <SDesc> <Summary> <SSum> <Keyword w="Speed of Light"/> Short Summary Text here. </SSum> <LSum> Long Summary. </LSum> </Summary> </SDesc> <LDesc> Complete Description of the Article. </LDesc> </Doc> <Doc> <Title name="Vibration Analysis" author="John Best" /> <SDesc> <Summary> <SSum> <Keyword w="Vibration"/> Short Summary Text here. </SSum> <LSum> <P>Long Summary Para 1</P> <P>Long Summary Para 2</P> </LSum> </Summary> </SDesc> <LDesc> Complete Description of the Article. </LDesc> </Doc> </Docs>

Execution of below query is taking around 1 min !!!

for $db in("Doc1","Doc2", "Doc3") for $x in doc($db)/Docs/Doc where $x/SDesc/Summary/SSum/Keyword/lower-case(@w) contains text "vibration" and ($x/SDesc/Summary/LSum/P/text() contains text "spring" all words or SDesc/Summary/SSum/text() contains text "spring" all words) return $x/Title/@name

Can this be queried using ft:search() ? I tried but failed.

-- Dirk Kirsten, BaseX GmbH, http://basex.org |-- Firmensitz: Blarerstrasse 56, 78462 Konstanz |-- Registergericht Freiburg, HRB: 708285, Geschäftsführer: | Dr. Christian Grün, Dr. Alexander Holupirek, Michael Seiferle `-- Phone: 0049 7531 28 28 676, Fax: 0049 7531 20 05 22