Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 24676 invoked from network); 15 Aug 2007 12:35:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Aug 2007 12:35:11 -0000 Received: (qmail 20688 invoked by uid 500); 15 Aug 2007 12:35:08 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 20672 invoked by uid 500); 15 Aug 2007 12:35:08 -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 20663 invoked by uid 99); 15 Aug 2007 12:35:08 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Aug 2007 05:35:08 -0700 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FAKE_REPLY_C,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of marcel.reutegger@gmx.net designates 213.165.64.20 as permitted sender) Received: from [213.165.64.20] (HELO mail.gmx.net) (213.165.64.20) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 15 Aug 2007 12:35:05 +0000 Received: (qmail 3561 invoked by uid 0); 15 Aug 2007 12:34:43 -0000 Received: from 62.192.10.254 by www100.gmx.net with HTTP; Wed, 15 Aug 2007 14:34:43 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" Date: Wed, 15 Aug 2007 14:34:43 +0200 From: "Marcel Reutegger" Message-ID: <20070815123443.124190@gmx.net> MIME-Version: 1.0 Subject: Re: Does jackrabbit suffer from n+1 SQL SELECT queries? To: users@jackrabbit.apache.org X-Authenticated: #894343 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX18PUkZZXpYP8kkkIHBzHR/79v36Lb6zt7Z/s/mgsz yDjQ27ofJZdYXscubGz2lqp2LW4m5hSVJNjg== Content-Transfer-Encoding: 8bit X-GMX-UID: 18DwdbIHPTR+DrCWPDIwjWk5c2tpZIsP X-Virus-Checked: Checked by ClamAV on apache.org Brian Thompson wrote: > Would it be viable to add an option to retrieve everything in a given > NodeIterator as a single DB query when a DB persistence manager is used? It > seems to me that such an option would help out a lot for cases like > retrieving search results, getting all children of a node, etc. This requires substantial changes to the core of jackrabbit and the PersistenceManager interface. Currently only one item at a time can be requested from a persistence manager. But maybe it's worth the effort. regards marcel -- Psssst! Schon vom neuen GMX MultiMessenger geh�rt? Der kanns mit allen: http://www.gmx.net/de/go/multimessenger