Hi John, thanks Dirk,
for $dbname in ('physicsSD', 'physicsLD') for $x in doc($dbname)//Doc[SD/Info/ text() contains text {"emf waves"} all words or LD/Info/Para/text() contains text {"emf waves"} all words]
due to the dynamic choice of addressed databases, the full-text index will not be utilized. The ft:search function can be used instead [1].
Hope this helps, Christian
[1] http://docs.basex.org/wiki/Full-Text_Module#ft:search
order by xs:integer($x/Details/Year) descending return $x/Doc
This query retrieves data in approx. 83000 ms (83 Sec)
But when executed on INDIVIDUAL DBs, the total time is very very less compared to the above. Its only 4500 ms (4.5 sec) for BOTH !!!
-- Have a nice day JBest
BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk