jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eugeny N Dzhurinsky <b...@redwerk.com>
Subject simple XPATH query optimization
Date Mon, 03 Dec 2007 16:40:58 GMT
Hello all!

We have a node with 50 children, each child has the property URL, this
property holds the URL.

We want to use XPATH to query the nodes like this:

/jcr:root/websites/*[jcr:like(@URL, "%\/\/www.domain.com%")]

However for some reason this query takes about 30 seconds to execute

JackRabbit version is 1.3.1, repository is configured to use local filesystem 
storage and file bundle persistence manager.

Could somebody please advice how can we speed up this query?

Thank you in advance!

Eugene N Dzhurinsky

View raw message