Return-Path: Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org Received: (qmail 853 invoked from network); 24 Apr 2007 09:09:27 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 24 Apr 2007 09:09:27 -0000 Received: (qmail 76430 invoked by uid 500); 24 Apr 2007 09:09:32 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 76416 invoked by uid 500); 24 Apr 2007 09:09:32 -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 76403 invoked by uid 99); 24 Apr 2007 09:09:32 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of marcin.j.nowak@comarch.com designates 217.74.68.69 as permitted sender) Received: from [217.74.68.69] (HELO lucy.comarch.pl) (217.74.68.69) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 24 Apr 2007 02:09:31 -0700 Received: from localhost (localhost [127.0.0.1]) by lucy.comarch.pl (Postfix) with ESMTP id 55F9E27DA7 for ; Tue, 24 Apr 2007 11:08:33 +0200 (CEST) Received: from lucy.comarch.pl ([127.0.0.1]) by localhost (lucy [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16516-02 for ; Tue, 24 Apr 2007 11:08:33 +0200 (CEST) Received: from [10.132.7.160] (pcmnowak.krakow.comarch [10.132.7.160]) by lucy.comarch.pl (Postfix) with ESMTP id 0C8F027D95 for ; Tue, 24 Apr 2007 11:08:33 +0200 (CEST) Message-ID: <462DC93C.2040501@comarch.com> Date: Tue, 24 Apr 2007 11:09:16 +0200 From: Marcin Nowak User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: users@jackrabbit.apache.org Subject: Re: eXist References: <462C5066.5040501@comarch.com> <462C90A5.1050009@comarch.com> <510143ac0704230523n1c09e2f4wfde1cb5e62d42e6f@mail.gmail.com> <462D9DC5.3090402@comarch.com> <462DA7D2.7070908@comarch.com> <510143ac0704240117y15406048u1a369cebb0acaeda@mail.gmail.com> In-Reply-To: <510143ac0704240117y15406048u1a369cebb0acaeda@mail.gmail.com> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms010004050708020208040806" X-Virus-Scanned: by SmartQbits at ComArch X-Virus-Checked: Checked by ClamAV on apache.org --------------ms010004050708020208040806 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit So you suggest that storing data as attributes could be more efficient in Jackrabbit? After weekend I'll try to provide some results of the same test cases but with another set of XML-s with storing based on attributes, I'll also make some comparison charts. If there are any give me some suggestions how data should be organized to fit best in Jackrabbit architecture - what should I avoid, where are the limitations/depth, number of subtags on one level, etc./ ? Jukka Zitting wrote: > Hi, > > On 4/24/07, Marcin Nowak wrote: >> I can't share those files but I can give you some stats: > > Your data set seems to primarily use tags instead of attributes for > storing content. Jackrabbit nodes are quite a bit "heavier" than DOM > nodes, which probably explains the difference in performance. > > As a rule of thumb I've sometimes used a rough metric that a > Jackrabbit node is about an order of magnitude more expensive than a > DOM node. I think we probably could improve this quite a bit. > > BR, > > Jukka Zitting > --------------ms010004050708020208040806 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJCzCC Av0wggHloAMCAQICAhG3MA0GCSqGSIb3DQEBBQUAMEExEDAOBgNVBAoTB0NPTUFSQ0gxDzAN BgNVBAsTBnBlb3BsZTEcMBoGA1UEAxMTQ09NQVJDSCBQRVJTT05BTCBDQTAeFw0wNjEwMTcx NDI1NTdaFw0wNzEwMTcxNDI1NTdaMEsxEDAOBgNVBAoTB2NvbWFyY2gxDzANBgNVBAsTBnBl b3BsZTEPMA0GA1UECxMGS3Jha293MRUwEwYDVQQDEwxNYXJjaW4gTm93YWswgZ8wDQYJKoZI hvcNAQEBBQADgY0AMIGJAoGBANqltirtmXbrbuCyboXb5nXXrYcRPOhi0lmYn6FVRKqC+p2A Ys6pQoeJ23zjQgkPrROZqhARX8qZ54Po8NBTbg2+3p9zPAvOPXCQDT1dcWFlXFisaRiEZD/e 8e7AL2BLymm7B4//gIYhhF1IjMmkWSWybU/aseRBAql2JIQZMXrXAgMBAAGjeTB3MHUGA1Ud EQRuMGyBGE1hcmNpbmouTm93YWtAY29tYXJjaC5wbIEZTWFyY2luai5Ob3dha0Bjb21hcmNo LmNvbYEZTWFyY2luLmouTm93YWtAY29tYXJjaC5wbIEaTWFyY2luLmouTm93YWtAY29tYXJj aC5jb20wDQYJKoZIhvcNAQEFBQADggEBACZ65Pt0TNC5cH8coq7aYyhgg2i5M7oNSrgdhSjc IYYqRRGqEy322KBwD8PW0AusblQudEYM6+gdN6/7vV+ZB8PcwwS6uB1FW4njf7BcKfCPceVR yRwNFTVo6jBVMqMDASD1wX1QGreNp+v6mVhv4K8RbvIewWDAp+48B/Z6UN8NnlBDiB91GiI8 DfGp+8h/bqpCRHFTk1O03ig8mFwZRwlstso+N5buD8hzFHccYKFgLga2rr6wOXOp4C5eNZfd Cgom9vir/hygAyXwrXN7qzAmNhZNzcgqFoi5xiTsIvaKpm/VXq6Bgj4qfhRI0wRH+0/jNDhZ SK03JCVf+S2Zo28wggL9MIIB5aADAgECAgIRtzANBgkqhkiG9w0BAQUFADBBMRAwDgYDVQQK EwdDT01BUkNIMQ8wDQYDVQQLEwZwZW9wbGUxHDAaBgNVBAMTE0NPTUFSQ0ggUEVSU09OQUwg Q0EwHhcNMDYxMDE3MTQyNTU3WhcNMDcxMDE3MTQyNTU3WjBLMRAwDgYDVQQKEwdjb21hcmNo MQ8wDQYDVQQLEwZwZW9wbGUxDzANBgNVBAsTBktyYWtvdzEVMBMGA1UEAxMMTWFyY2luIE5v d2FrMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDapbYq7Zl2627gsm6F2+Z1162HETzo YtJZmJ+hVUSqgvqdgGLOqUKHidt840IJD60TmaoQEV/KmeeD6PDQU24Nvt6fczwLzj1wkA09 XXFhZVxYrGkYhGQ/3vHuwC9gS8ppuweP/4CGIYRdSIzJpFklsm1P2rHkQQKpdiSEGTF61wID AQABo3kwdzB1BgNVHREEbjBsgRhNYXJjaW5qLk5vd2FrQGNvbWFyY2gucGyBGU1hcmNpbmou Tm93YWtAY29tYXJjaC5jb22BGU1hcmNpbi5qLk5vd2FrQGNvbWFyY2gucGyBGk1hcmNpbi5q Lk5vd2FrQGNvbWFyY2guY29tMA0GCSqGSIb3DQEBBQUAA4IBAQAmeuT7dEzQuXB/HKKu2mMo YINouTO6DUq4HYUo3CGGKkURqhMt9tigcA/D1tALrG5ULnRGDOvoHTev+71fmQfD3MMEurgd RVuJ43+wXCnwj3HlUckcDRU1aOowVTKjAwEg9cF9UBq3jafr+plYb+CvEW7yHsFgwKfuPAf2 elDfDZ5QQ4gfdRoiPA3xqfvIf26qQkRxU5NTtN4oPJhcGUcJbLbKPjeW7g/IcxR3HGChYC4G tq6+sDlzqeAuXjWX3QoKJvb4q/4coAMl8K1ze6swJjYWTc3IKhaIucYk7CL2iqZv1V6ugYI+ Kn4USNMER/tP4zQ4WUitNyQlX/ktmaNvMIIDBTCCAe2gAwIBAgIBATANBgkqhkiG9w0BAQUF ADAsMRAwDgYDVQQKEwdDT01BUkNIMRgwFgYDVQQDEw9DT01BUkNIIFJPT1QgQ0EwHhcNMDMw MzI2MTAwNTU1WhcNMDgwMzI0MTAwNTU1WjBBMRAwDgYDVQQKEwdDT01BUkNIMQ8wDQYDVQQL EwZwZW9wbGUxHDAaBgNVBAMTE0NPTUFSQ0ggUEVSU09OQUwgQ0EwggEiMA0GCSqGSIb3DQEB AQUAA4IBDwAwggEKAoIBAQCxN4k28R7CkRuX6lRXtHkBo39Qo7mGrIFHO81eND1JNvnIO+MX jrQ/nWm1VIAJwQDrFVGc2V1ZvuIJJqZ+gvRegYmdzB5c3fDyd46yUQlfrv+SHHHvKx0+hvcd LI6N3S7BZTPUiYPjJZcR8ZuAacVnD67IQzPIbCVHdYh1e5SLxfHsJdnCC9XiPfJXlEPC4/ye r34RzVmIbPBiCp+j3Bh7y7c+7y57xnVHQvbQ5VSdDmZCmEne5u0TcWmmYIXtmSH5uLwJaIFf oHd6CcSko0lpR9cwES765PxTgjAJdtZ9cdFomTNqQ8T4Brkp/385/BTtuoxbpwe4osX8I163 xghpAgMBAAGjHTAbMAwGA1UdEwQFMAMBAf8wCwYDVR0PBAQDAgEGMA0GCSqGSIb3DQEBBQUA A4IBAQBl/PzjtGzjnAFDCD4k+NMX5MJu4UpBWwY9IaSyjm5EuSM4XQLzTWQo7JgFkhwHpsiP 7eek5EsAgBD7zuEQZ2a7SNZ2+454Rx2Yw0Am5XZ062vjWtN/Mo/7DBgW9HxVbIQQVoe5d379 PxoYahDsyEPQCJMBaoS3xZ3ohMFAt7K/3IQTTFJXf7TflKqqQ7uOLoyg5xUBFZA2M1tglKnX Su+MdIVyiPfVLAzBLoQ9kFe0IA58YWgvh/DEvLwmvk3jeIZqxylgIxt67ZjuQWxmPYLH6C5X koXRlVB1IKKRI5DmMtiXCtGVcSI1YA8RoUSnolaqvfQJgnCfogiojggw0w02MYICVDCCAlAC AQEwRzBBMRAwDgYDVQQKEwdDT01BUkNIMQ8wDQYDVQQLEwZwZW9wbGUxHDAaBgNVBAMTE0NP TUFSQ0ggUEVSU09OQUwgQ0ECAhG3MAkGBSsOAwIaBQCgggFjMBgGCSqGSIb3DQEJAzELBgkq hkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA3MDQyNDA5MDkxNlowIwYJKoZIhvcNAQkEMRYE FNsF+FtTd9isOVBrCjL5mQZSKtLJMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYI KoZIhvcNAwICAgCAMA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMFYG CSsGAQQBgjcQBDFJMEcwQTEQMA4GA1UEChMHQ09NQVJDSDEPMA0GA1UECxMGcGVvcGxlMRww GgYDVQQDExNDT01BUkNIIFBFUlNPTkFMIENBAgIRtzBYBgsqhkiG9w0BCRACCzFJoEcwQTEQ MA4GA1UEChMHQ09NQVJDSDEPMA0GA1UECxMGcGVvcGxlMRwwGgYDVQQDExNDT01BUkNIIFBF UlNPTkFMIENBAgIRtzANBgkqhkiG9w0BAQEFAASBgLlOVou1nwsrm5ObOLx100gzw8AkMRDG bBzPvV38rC1c5H+HIh3hkZ5+UeUUF7+tGkt3XzJ6Hqc3AH6erXmEuvt/XeyyNrNu0Tbddpn0 EeKuJqJ0LJwQkTxmuY/4Mhsz24nkQvZyZICC09lhrNY7i/Rm9eZbwxtky1w6NLNt6iBPAAAA AAAA --------------ms010004050708020208040806--