Return-Path: 
 <users-return-11165-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 89791 invoked from network); 10 Apr 2009 22:37:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 10 Apr 2009 22:37:25 -0000
Received: (qmail 68776 invoked by uid 500); 10 Apr 2009 22:37:24 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 68724 invoked by uid 500); 10 Apr 2009 22:37:24 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 68713 invoked by uid 99); 10 Apr 2009 22:37:24 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2009 22:37:24 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2009 22:37:16 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1LsPLD-0000kQ-De
	for users@jackrabbit.apache.org; Fri, 10 Apr 2009 15:36:55 -0700
Message-ID: <22995690.post@talk.nabble.com>
Date: Fri, 10 Apr 2009 15:36:55 -0700 (PDT)
From: pkrishna <prabhakar.krishnaswami@ge.com>
To: users@jackrabbit.apache.org
Subject: XPath query against a remote database is very slow
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: prabhakar.krishnaswami@ge.com
X-Virus-Checked: Checked by ClamAV on apache.org


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.