Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 93538 invoked from network); 7 Aug 2007 19:17:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Aug 2007 19:17:34 -0000 Received: (qmail 53833 invoked by uid 500); 7 Aug 2007 19:17:33 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 53812 invoked by uid 500); 7 Aug 2007 19:17:33 -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 53803 invoked by uid 99); 7 Aug 2007 19:17:33 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2007 12:17:33 -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: local policy) Received: from [216.170.99.246] (HELO mail.authsum.com) (216.170.99.246) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Aug 2007 19:17:27 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mail.authsum.com (Postfix) with ESMTP id 6DCFF781FF for ; Tue, 7 Aug 2007 15:17:06 -0400 (EDT) X-Virus-Scanned: amavisd-new at X-Spam-Score: -4.099 X-Spam-Level: Received: from mail.authsum.com ([127.0.0.1]) by localhost (mail.authsum.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id qsCEP6BrRCgd for ; Tue, 7 Aug 2007 15:17:02 -0400 (EDT) Received: from mail.authsum.com (mail.authsum.com [216.170.99.246]) by mail.authsum.com (Postfix) with ESMTP id EB0AC781FE for ; Tue, 7 Aug 2007 15:17:02 -0400 (EDT) Message-ID: <14792375.7261186514222706.JavaMail.root@mail.rhoderunner.com> Date: Tue, 7 Aug 2007 15:17:02 -0400 (EDT) From: Phillip Rhodes To: users@jackrabbit.apache.org Subject: Re: ObjectPersistenceManager vs SimpleDbPersistenceManager In-Reply-To: <03dc01c7d90d$602c80c0$20858240$@co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Originating-IP: [209.166.180.139] X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No, score=-4.099 tagged_above=-10 required=6.6 tests=[ALL_TRUSTED=-1.8, AWL=0.300, BAYES_00=-2.599] Thanks for the suggestion. I did just now give the bundle Persistence manager a shot and it did not resolve my sql query per node problem. Thanks again! Phillip ----- Original Message ----- From: "sbarriba" To: users@jackrabbit.apache.org Sent: Tuesday, August 7, 2007 12:09:46 PM (GMT-0500) America/New_York Subject: RE: ObjectPersistenceManager vs SimpleDbPersistenceManager Hi Phillip, Have you tried the new org.apache.jackrabbit.core.persistence.bundle.*PersistenceManagers? e.g. org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager Regards, Shaun. -----Original Message----- From: Phillip Rhodes [mailto:spamsucks@rhoderunner.com] Sent: 07 August 2007 16:51 To: users Subject: ObjectPersistenceManager vs SimpleDbPersistenceManager 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