Return-Path: 
 <users-return-4034-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org
Received: (qmail 23949 invoked from network); 16 Jul 2007 08:18:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 16 Jul 2007 08:18:05 -0000
Received: (qmail 82017 invoked by uid 500); 16 Jul 2007 08:18:07 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 81653 invoked by uid 500); 16 Jul 2007 08:18:06 -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 81644 invoked by uid 99); 16 Jul 2007 08:18:06 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jul 2007 01:18:06 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of sridhar.raman@gmail.com
 designates 64.233.184.235 as permitted sender)
Received: from [64.233.184.235] (HELO wr-out-0506.google.com) (64.233.184.235)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Jul 2007 01:18:03 -0700
Received: by wr-out-0506.google.com with SMTP id 71so1091726wri
        for <users@jackrabbit.apache.org>;
 Mon, 16 Jul 2007 01:17:42 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=qsqU/lZN3S/3gVEcMcea+/d4wcZkw5BVV43AG6xxTL7OZ0lZkdHODAI9JH2M8w+0sXITWZLjoSPZlfoTbISbAT9lgF0Wi2ywbcqrSmqom0N8FXul9r+gqVUVtjB9GTSPUcXdCH8IdrAZy1vPBB/YJuD30ZA02F/qnXk1w6CPR1U=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=mZ79VtXWOaABH+cFt5pHHVeQjb171Z8ywcuZwMVfHf/aqEAVmyekbBj5niu4yJrnyRAlVoarpKVrschzFhoyjE+f+qX8Zj5wxDwsp3ToMl1pMUV741LLOO4lFD+ByScpRCkdRKuRDBiHMNdcuVh0qcwLu5o0ILEeyk9PZQo1lpU=
Received: by 10.78.130.6 with SMTP id c6mr1112395hud.1184573860919;
        Mon, 16 Jul 2007 01:17:40 -0700 (PDT)
Received: by 10.78.160.18 with HTTP; Mon, 16 Jul 2007 01:17:40 -0700 (PDT)
Message-ID: <227621ad0707160117yd9c0005k1561de528f144517@mail.gmail.com>
Date: Mon, 16 Jul 2007 13:47:40 +0530
From: "Sridhar Raman" <sridhar.raman@gmail.com>
To: users@jackrabbit.apache.org
Subject: Re: Saving of nodes takes too long/Indexing configuration
In-Reply-To: <227621ad0707152331u45942942x99d943a319863714@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_49540_29984487.1184573860871"
References: <227621ad0707140143w2f8e0a12hd02d8fac7b6b59fa@mail.gmail.com>
	 <510143ac0707150308t40ac6c68o496fd3ea10556df0@mail.gmail.com>
	 <227621ad0707152331u45942942x99d943a319863714@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

------=_Part_49540_29984487.1184573860871
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Also, how do I switch to bundle persistence?  Currently, this is the
configuration in my workspace.xml file:

>     <PersistenceManager class="
> org.apache.jackrabbit.core.state.db.DerbyPersistenceManager">
>      <param name="url" value="jdbc:derby:${wsp.home}/db;create=true"/>
>      <param name="schemaObjectPrefix" value="${wsp.name}_"/>
>     </PersistenceManager>
>

How do I change it to include the bundle persistance for Derby?

Thanks,
Sridhar

On 7/16/07, Sridhar Raman <sridhar.raman@gmail.com> wrote:
>
> I use DerbyPersistenceManager and LocalFileSystem.  So would I be able to
> switch to bundle persistence in this case, and would it be helpful?
>
> On 7/15/07, Jukka Zitting <jukka.zitting@gmail.com> wrote:
> >
> > Hi,
> >
> > On 7/14/07, Sridhar Raman <sridhar.raman@gmail.com> wrote:
> > > I use Jackrabbit extensively, and one problem that I seem to run into
> > a lot
> > > of times is when I import data, and save the nodes.  For saving 4000
> > nodes,
> > > it almost takes 32 mins to execute the session.save() command.  Any
> > way of
> > > fixing this?
> > >
> > > Is it probably because all my data is getting indexed?  Could I
> > somehow
> > > specify only specific properties/types to be indexed?
> >
> > I much more suspect that the time is spent talking to the persistence
> > store. Are you using an external database for persistence?
> >
> > The traditional database persistence managers issue a separate SQL
> > statement (causing a network roundtrip to the database) for each node
> > *and* property being saved, which can quickly end up taking a lot of
> > time especially if the network roundtrip to a database server takes
> > more than a few milliseconds.
> >
> > Good solutions to this problem are either to switch to the bundle
> > persistence (which uses just a single statement for a node and all
> > it's properties) included in Jackrabbit 1.3 and/or using an embedded
> > database like the default Derby.
> >
> > BR,
> >
> > Jukka Zitting
> >
>
>

------=_Part_49540_29984487.1184573860871--