Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5F4DC10CED for ; Wed, 20 Nov 2013 19:43:39 +0000 (UTC) Received: (qmail 17056 invoked by uid 500); 20 Nov 2013 19:43:38 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 17026 invoked by uid 500); 20 Nov 2013 19:43:38 -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 17016 invoked by uid 99); 20 Nov 2013 19:43:37 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Nov 2013 19:43:37 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [176.9.111.84] (HELO ssl.backendmedia.com) (176.9.111.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Nov 2013 19:43:30 +0000 Received: from localhost (unknown [127.0.0.1]) by ssl.backendmedia.com (Postfix) with ESMTP id 0D4A95EFE381 for ; Wed, 20 Nov 2013 19:43:12 +0000 (UTC) X-Virus-Scanned: amavisd-new at backendmedia.com Received: from ssl.backendmedia.com ([127.0.0.1]) by localhost (hq2.backendmedia.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id p8Do0ed89iI6 for ; Wed, 20 Nov 2013 20:43:11 +0100 (CET) Received: from [192.168.0.177] (217-162-130-254.dynamic.hispeed.ch [217.162.130.254]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: smith@pooteeweet.org) by ssl.backendmedia.com (Postfix) with ESMTPSA id B4AB65EFE379 for ; Wed, 20 Nov 2013 20:43:11 +0100 (CET) From: Lukas Kahwe Smith Content-Type: multipart/signed; boundary="Apple-Mail=_59CD987B-5B41-4F9D-9550-7254E4738DD5"; protocol="application/pgp-signature"; micalg=pgp-sha1 Message-Id: <66516541-A78C-4694-8C22-EEDABD8EE573@pooteeweet.org> Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) Subject: Re: Jackrabbit & Performance Date: Wed, 20 Nov 2013 20:43:08 +0100 References: <528CFF15.4060403@team.orcon.net.nz> To: users@jackrabbit.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1510) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_59CD987B-5B41-4F9D-9550-7254E4738DD5 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On Nov 20, 2013, at 20:39 , Enrique Medina Montenegro = wrote: > Bertrand, >=20 > Your algorithm is exactly the approach I followed, but I noticed a = decrease > in performance as the import was progressing, with response times to = just > lookup the exact path (i.e. session.getNode("/marks/XXX/YYY")) above 2 > seconds, even when calling Session.save() every 1000 or 500 or 100 > records... >=20 > Using Jackrabbit 2.7.0 btw, because it's the only one working with = Spring > Modules for JCR 0.8b If you can sort the data in the SQL query on the RDBMS you should be = able to do much less session.getNode() calls for getting the relevant = parents for the mark to add.=20 regards, Lukas Kahwe Smith smith@pooteeweet.org --Apple-Mail=_59CD987B-5B41-4F9D-9550-7254E4738DD5 Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=signature.asc Content-Type: application/pgp-signature; name=signature.asc Content-Description: Message signed with OpenPGP using GPGMail -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org iEYEARECAAYFAlKNEMwACgkQ2FnmJDTfRPeNXACeICHsYnJPL3hjEHeT9Ie5R0qW n6gAoKAyoP1SQolIZwswvmqOPLg4o8QW =Jc3u -----END PGP SIGNATURE----- --Apple-Mail=_59CD987B-5B41-4F9D-9550-7254E4738DD5--