Main Page » Mailing List » September 2012

How to lower the Full-Text search time??

Thursday, 20 September 2012 · 1 message
JB
John Best20 Sep 2012 13:44 #
Hi there, Below is my XML Structure –
<Docs>

            <Doc>

                        <DocTitle C=”1”></DocTitle>

                        <MainDesc></MainDesc>

                        <FullDesc></FullDesc>

            </Doc>

            <Doc>

                        <DocTitle C=”2”></DocTitle>

                        <MainDesc></MainDesc>

                        <FullDesc></FullDesc>

            </Doc>
…………………. …………………. ………………….
</Docs>
There are at least 6000 Doc (more to be added soon). I have created a FT Index of the same. To search a particular word, which might be either in <MainDesc> or in <FullDesc>, below are my queries – Query No -1 (Time taken is 21-22 Secs)
               data(doc('sample')/Docs/Doc[MainDesc[. contains text
{'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]]/DocTitle/@C)
Query No -2 (Time taken is 25-26 Secs)
               for $x in doc('sample')/Docs/Doc
where $x[MainDesc[. contains text {'unfavorable'}] or FullDesc[. contains text {'unfavorable'}]] return $x/DocTitle/@C The time taken is too much. How can I lower this…? I tried ft:search(), but it doesn’t fits in here as ft:search wont return Nodes. * * Have a nice day Regards, JBest

Written for BaseX 7.3. BaseX may have changed since: please check the current documentation.

« (no subject)Indexes update »
⚡Generated with XQuery