I have been testing the performance of the following XPATH query String query = "//element(*, " + JackRabbitNodeDefinitions.FROZEN_NODE.getNodeValue() + ")[" + getXPathQuery(ctx, metadata) + "]";
where method getXPathQuery translates to a certain set of attributes. We have 2 configurations pointed to by two different repository.xmls. One of them points to a local database (database on the samebox where the test is executing) and another one a remote database. When I test against a local database I am able to retrieve more than 2000 nodes within 300~500ms. But when I test against a remote database the same query takes about 7000ms to retrieve 4 nodes. I do agree there could a some network latency but the difference in times seems to reflect some other issues. Here are the parameters we use for SearchIndex (repository.xml): <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex"> <!-- --> </SearchIndex> Any ideas\help on the cause of this problem would be appreciated. -- View this message in context: http://www.nabble.com/XPath-query-against-a-remote-database-is-very-slow-tp22995690p22995690.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.