-- Jens Erat [phone]: tel:+49-151-56961126 [mail]: mailto:email@jenserat.de [jabber]: xmpp:jabber@jenserat.de [web]: http://www.jenserat.de PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B Am 19.09.2012 um 10:22 schrieb basex@phpexpert.net: > My searches are > > <no>{let $quasi := (for $x in /record where ft:search($x, 'double') and ($x/item[@name="STATUS"]/value/string() = "edited") return <quasi>{data($x/@id)}<content>{$x//value[text() contains text 'double']}</content></quasi>) return $quasi }</no> > > > <no>{let $quasi := (for $x in /record where ($x//value[text() contains text 'double']) and ($x/item[@name="STATUS"]/value/string() = "edited") return <quasi>{data($x/@id)}<content>{$x//value[text() contains text 'double']}</content></quasi>) return $quasi }</no> > > > These searches take a lot of time (about 300 seconds) cause of nearly 600.000 objects (about 4 GB data) to search through > > A Fulltext search wich only delivers the textnodes only takes 2 seconds to deliver text results > > > > On Wed, 19 Sep 2012 09:55:50 +0200, Jens Erat jens.erat@uni-konstanz.de wrote: >> Hi Marcus, >> >> `ft:search(…)` is built for returning text nodes, have a look at the >> [documentation]. If you want to get the nodes, you should use the more >> general [full text expressions]. >> >> If you need help transforming your query, would you please paste your >> query (or better: the full text search relevant part of it)? >> >> Regards, >> Jens >> >> [documentation]: http://docs.basex.org/wiki/Full-Text_Module#ft:search >> [full text expressions]: http://docs.basex.org/wiki/Full-Text >> >> -- >> Jens Erat >> >> [phone]: tel:+49-151-56961126 >> [mail]: mailto:email@jenserat.de >> [jabber]: xmpp:jabber@jenserat.de >> [web]: http://www.jenserat.de >> >> PGP: 350E D9B6 9ADC 2DED F5F2 8549 CBC2 613C D745 722B >> >> >> >> Am 19.09.2012 um 09:33 schrieb basex@phpexpert.net: >> >>> Hi @all, >>> >>> is there a way if i use ft:search on the database to get the nodes of results back instead of just the results? >>> >>> >>> Regards >>> >>> >>> Marcus >>> >>> _______________________________________________ >>> BaseX-Talk mailing list >>> BaseX-Talk@mailman.uni-konstanz.de >>> https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk >