Re: [basex-talk] Performance related query.

Hi Ankit, have you already compared the query info outoput? Best, Christian On Fri, Mar 27, 2015 at 10:35 AM, ankit kumar anky4b...@gmail.com wrote: Hi, I am getting performance issue while using my own xquery library. I have written an xquery module which contains a single function which

Re: [basex-talk] Performance related query.

Hi, Optimized query without module import count(db:attribute(large_products, distinct-values(db:open-pre(large_products,0)/products/*[@catid]/@catid))/self::id/parent::p:category[parent::products/parent::document-node()]) optimized query with module import count(let $catRefs_4 :=

[basex-talk] Performance related query.

Hi, I am getting performance issue while using my own xquery library. I have written an xquery module which contains a single function which return all the categories belong to a set of products as given below. Also there is one constrain that i cannot pass all the category to the

Re: [basex-talk] Performance related query.

Thanks Christian, I am able to solve the issue. Thanks, Ankit On 27 March 2015 at 17:10, Christian Grün christian.gr...@gmail.com wrote: Hi Ankit, The query info output indicates that only the first query is rewritten for index access (→ db:attribute). If you always work with the same

Re: [basex-talk] Performance related query.

Hi Ankit, The query info output indicates that only the first query is rewritten for index access (→ db:attribute). If you always work with the same database instance, the following version of your query should be evaluated faster: declare function lib:getCategory($products) { let