Thanks Andreas,

Executed index:facets("db")

After which the offending query and the results din't improve significantly (As it stands doc('db')/repository/items/*// 12500 object elements).

I have now selected to only count the direct descendants of a folder with

count(distinct-values(for $item in doc('db')/repository/items/*//object where $item/paths/path[@uuid='028c2c53-a0fb-4611-bec5-62a33321a026'] return $item/@uuid))

and it performs all right.

/ Chris

From: Andreas Weiler andreas.weiler@uni-konstanz.de Date: Sunday, 21 October 2012 13:24 To: Christopher Harper christopher@sardion.fi Cc: basex-talk@mailman.uni-konstanz.de Subject: Re: [basex-talk] BaseX performance

Hi Chris,

probably the index:facets function [1] is a solution for you. The number of distinct-values for each facet depends on the maxcat setting [2].

Note: if the content of your database changes you have to recreate the index.

Kind regards, Andreas

[1] http://docs.basex.org/wiki/Index_Module#index:facets [2] http://docs.basex.org/wiki/Options#MAXCATS

Am 20.10.2012 um 13:58 schrieb Christopher Harper:

...

Hi @ll,

I'm working on an CM/DM solution that uses BaseX as the metadata repository. This isn't my first stab at a DM/CM system just that the XML database portion is new to meŠ

Now when trying to scale the system up I find that I have created at least one offending query:

count( distinct-values( let $item := doc('db')/repository/items/*//object for $path in $item/paths/path where starts-with($path/@name, '/Root/Temp/Import/') return $item/@uuid ) )

The '*/' could be replaced with 'documents/document' and 'folders', but that would be two separate queries and their individual times would still be offending.

The goal of the query is to list items placed into a certain folder structure represented by items in the database.

This seems like a straight forward query but I'm stumped at trying to get it to perform adequately.

Any suggestions?

/ Chris _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk