[MarkLogic Dev General] Improving Lookup Performance

Danny Sokolsky dsokolsky at marklogic.com
Wed Oct 29 07:56:40 PST 2008


As a first step, try putting the predicate at the end of your XPath
expression.  Something like this:

fn:collection()/doc/item/classification/[@value = "class1"]

Does that help? 

-Danny

-----Original Message-----
From: general-bounces at developer.marklogic.com
[mailto:general-bounces at developer.marklogic.com] On Behalf Of Steve
Sent: Wednesday, October 29, 2008 7:02 AM
To: general at developer.marklogic.com
Subject: [MarkLogic Dev General] Improving Lookup Performance

Folks,

I've got a MarkLogic instance running with approximately 100,000
documents in it (this needs to scale to approximately 2.5 million),
and I'm doing some basic lookups etc.

I've been executing queries such as those shown below, however the
results are taking a long time to come back. I've got indexes against
the elements and attributes that I'm trying to lookup, however I'm
looking for other ways to improve performance of queries. Anybody got
any suggestions??

example queries

fn:collection()[/doc/item/classification/@value = "class1"]

fn:colleciton()[//classification/@value = "class1"]

fn:distinct-values(fn:collection()[/doc/item/name])
_______________________________________________
General mailing list
General at developer.marklogic.com
http://xqzone.com/mailman/listinfo/general


More information about the General mailing list