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