We are migrating from IPedo to Berkeley DB.

IPedo did not support multiple indices in their Xqueries, so we had to
concatenate some fields in to one field and index that field, the
Xqueries were really fast.

Unfortunately the same XQuery does not perform well in BerkeleyDB.

This is how we create the index for this filed (ContentKey) in
BerkeleyDB

addIndex '' 'ContentKey' edge-element-equality-string

and this is how I query using Java API.

queryContext.setEvaluationType(XmlQueryContext.Eag er);
queryContext.setVariableValue("ContentKey", new XmlValue(
"a0a0188000001115348efcc00000003XXXXXXXXXXXXXYYYYY YYYYYYYYY"));
// Declare the query string
String myQuery = "collection('db/title')/Record[ContentKey=
$ContentKey]";
// Prepare (compile) the query
XmlQueryExpression xmlQueryExpression =
dbManager.prepare(myQuery,queryContext);

1. What is wrong with the index or the way I am using the Java API ?
Changing the evaluation type to Lazy did not help at all.

2. The Query performs OK in dbxml.

3. Are there any other commercial/open source tools to evaluate the
performance of a Xquery in BerkeleyDB? Stylus Studio does not support
BDB - 2.3.10 yet.

Any help would be appreciated.

Thanks,
Suresh