From users-return-4497-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Thu Aug 09 13:47:57 2007 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 55406 invoked from network); 9 Aug 2007 13:47:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Aug 2007 13:47:57 -0000 Received: (qmail 34017 invoked by uid 500); 9 Aug 2007 13:47:55 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 33654 invoked by uid 500); 9 Aug 2007 13:47:55 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 33642 invoked by uid 99); 9 Aug 2007 13:47:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Aug 2007 06:47:55 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of thomas.tom.mueller@gmail.com designates 64.233.162.235 as permitted sender) Received: from [64.233.162.235] (HELO nz-out-0506.google.com) (64.233.162.235) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Aug 2007 13:47:51 +0000 Received: by nz-out-0506.google.com with SMTP id s18so204578nze for ; Thu, 09 Aug 2007 06:47:31 -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:content-transfer-encoding:content-disposition:references; b=awtuqOXH3ZQ2h6Qqpn9xcDtogw8sKkU+R7Nr0d1VJCzxrOs0DooZQ6wd3gfxnI2Xrd2G3cfU4oSwEM2ULxKK4nZzuTyAA7h969oFxtYgAmS/Wv/xPKXIFQKecueZzeVUZGYM71Bb09qOcJq5MnSTAGVM6Eb8nxz3ZtJYCwaxVCA= 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:content-transfer-encoding:content-disposition:references; b=QjMV9aMtyJoNpC7w4jQme2DP5bbIv9JLJRvyKUPkAfXZ3T+vmBYe5NnK2OAhmxBGB9gKNfsTCm8i9nk4Pvp+vgsDR5g7WWxFhC9ttoTcsoxiE04qi7UjYvq6QQmJgOX6ALFVbVMViO1ghMx/SLPkLNV10rljWHl3kMsKQWE7onI= Received: by 10.64.220.8 with SMTP id s8mr3675939qbg.1186667250922; Thu, 09 Aug 2007 06:47:30 -0700 (PDT) Received: by 10.65.15.10 with HTTP; Thu, 9 Aug 2007 06:47:30 -0700 (PDT) Message-ID: <5f211bd50708090647j4168ff77ua1b046478de520b@mail.gmail.com> Date: Thu, 9 Aug 2007 15:47:30 +0200 From: "Thomas Mueller" To: users@jackrabbit.apache.org Subject: Re: ObjectPersistenceManager vs SimpleDbPersistenceManager In-Reply-To: <18924955.6981186501846375.JavaMail.root@mail.rhoderunner.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <18924955.6981186501846375.JavaMail.root@mail.rhoderunner.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi, I suggest to use a Bundle Database Persistence Manager, for example: org.apache.jackrabbit.core.persistence.bundle.DerbyPersistenceManager ... or another database. The advantages are: - More stable than ObjectPersistenceManager - Faster than SimpleDbPersistenceManager Thomas On 8/7/07, Phillip Rhodes wrote: > Hello everyone, > > I did some debugging for my performance problems with SimpleDbPersistenceManager. > I ran SimpleDbPersistenceManager with jdbclogger and found that Jackrabbit will issue 2+ sql queries for each node as I iterator through the NodeIterator. This does not scale well for me. > > I am considering switching my workspace to use the ObjectPersistenceManager . I understand it is not reliable as the SimpleDbPersistenceManager, but since I won't be issuing 400+ database queries, I hope the performance for my application will improve. > > Am I risking the entire repository becoming corrupt, or just a few nodes becoming corrupt? I don't mind a few nodes becoming corrupt, but if the entire repo can become corrupt if the repository is killed, I would appreciate knowing this! > > > > > Thank you as always. > Phillip > > >