From owner-freebsd-database@FreeBSD.ORG Mon Apr 30 10:05:25 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 1F44B16A402 for ; Mon, 30 Apr 2007 10:05:25 +0000 (UTC) (envelope-from antoine@nagafix.co.uk) Received: from mail.nagafix.co.uk (mail.nagafix.co.uk [194.145.196.85]) by mx1.freebsd.org (Postfix) with ESMTP id DCB1113C4BA for ; Mon, 30 Apr 2007 10:05:24 +0000 (UTC) (envelope-from antoine@nagafix.co.uk) Received: from [192.168.0.6] (82-45-252-239.cable.ubr02.camd.blueyonder.co.uk [82.45.252.239]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: antoine@nagafix.co.uk) by mail.nagafix.co.uk (Postfix) with ESMTP id C3C6543B01 for ; Mon, 30 Apr 2007 10:41:09 +0100 (BST) Message-ID: <4635B9B4.3060905@nagafix.co.uk> Date: Mon, 30 Apr 2007 10:41:08 +0100 From: Antoine Martin User-Agent: Thunderbird 1.5.0.10 (X11/20070304) MIME-Version: 1.0 To: freebsd-database@freebsd.org X-Enigmail-Version: 0.94.3.0 OpenPGP: id=F18AD6BB; url=http://users.nagafix.co.uk/~antoine/antoine.asc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Subject: FreeBSD database performance via JDBC X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 30 Apr 2007 10:05:25 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi all, I published this paper a few weeks ago that some of you might find interesting (see part2: FreeBSD vs Linux vs Solaris): http://devloop.org.uk/documentation/database-performance/ I have to admit I have been a Linux user for many years and I was expecting it to come out on top, and if anything I expected Solaris to do better - after all the tests are written in Java. All my predictions turned out wrong! Feel free to forward to [advocacy], re-use the graphs, etc. Enjoy Antoine -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGNbm0GK2zHPGK1rsRCkKbAJ9AWLV/8O4kl0zveaGVapIlUxNkHQCfc0nP WSkM6BNRH4r0ZrDIpWOQ8/o= =h5A4 -----END PGP SIGNATURE----- From owner-freebsd-database@FreeBSD.ORG Wed May 2 10:05:06 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4406B16A406 for ; Wed, 2 May 2007 10:05:06 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id EE89313C45B for ; Wed, 2 May 2007 10:05:05 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1HjAeo-0004b6-W0 for freebsd-database@freebsd.org; Wed, 02 May 2007 10:57:54 +0200 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 02 May 2007 10:57:54 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 02 May 2007 10:57:54 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Wed, 02 May 2007 10:57:39 +0200 Lines: 38 Message-ID: References: <4635B9B4.3060905@nagafix.co.uk> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig3E6B4C449266F2F7FB48A6B2" X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 1.5.0.10 (X11/20060911) In-Reply-To: <4635B9B4.3060905@nagafix.co.uk> X-Enigmail-Version: 0.94.2.0 Sender: news Subject: Re: FreeBSD database performance via JDBC X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 May 2007 10:05:06 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig3E6B4C449266F2F7FB48A6B2 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Antoine Martin wrote: > I published this paper a few weeks ago that some of you might find > interesting (see part2: FreeBSD vs Linux vs Solaris): > http://devloop.org.uk/documentation/database-performance/ > I have to admit I have been a Linux user for many years and I was > expecting it to come out on top, and if anything I expected Solaris to > do better - after all the tests are written in Java. All my predictions= > turned out wrong! > Feel free to forward to [advocacy], re-use the graphs, etc. Can you try it again with libthr threading library=20 (http://threads.seas.gwu.edu/cgi-bin/man2web?program=3Dlibmap.conf§io= n=3D5)?=20 There's intent to make libthr the default for 7.0 and it may perform=20 worse in exactly this kind of benchmarks. --------------enig3E6B4C449266F2F7FB48A6B2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGOFKKldnAQVacBcgRAv2KAKCDA142ny8i5/LrZPbCETB5VU/UCQCgr+t8 7Oj5uF7s/obHrNtGb9SGmD4= =/dDp -----END PGP SIGNATURE----- --------------enig3E6B4C449266F2F7FB48A6B2-- From owner-freebsd-database@FreeBSD.ORG Wed May 2 18:25:00 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id F258D16A406 for ; Wed, 2 May 2007 18:24:59 +0000 (UTC) (envelope-from antoine@nagafix.co.uk) Received: from mail.nagafix.co.uk (mail.nagafix.co.uk [194.145.196.85]) by mx1.freebsd.org (Postfix) with ESMTP id BCB0E13C458 for ; Wed, 2 May 2007 18:24:59 +0000 (UTC) (envelope-from antoine@nagafix.co.uk) Received: from [192.168.0.6] (82-45-252-239.cable.ubr02.camd.blueyonder.co.uk [82.45.252.239]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: antoine@nagafix.co.uk) by mail.nagafix.co.uk (Postfix) with ESMTP id 2ECED43B43 for ; Wed, 2 May 2007 19:24:58 +0100 (BST) Message-ID: <4638D779.2070700@nagafix.co.uk> Date: Wed, 02 May 2007 19:24:57 +0100 From: Antoine Martin User-Agent: Thunderbird 1.5.0.10 (X11/20070304) MIME-Version: 1.0 To: freebsd-database@freebsd.org References: 4635B9B4.3060905@nagafix.co.uk X-Enigmail-Version: 0.94.3.0 OpenPGP: id=F18AD6BB; url=http://users.nagafix.co.uk/~antoine/antoine.asc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Subject: Re: FreeBSD database performance via JDBC X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 02 May 2007 18:25:00 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 >> I published this paper a few weeks ago that some of you might find >> interesting (see part2: FreeBSD vs Linux vs Solaris): >> http://devloop.org.uk/documentation/database-performance/ >> I have to admit I have been a Linux user for many years and I was >> expecting it to come out on top, and if anything I expected Solaris >> to do better - after all the tests are written in Java. All my >> predictions >> turned out wrong! >> Feel free to forward to [advocacy], re-use the graphs, etc. > Can you try it again with libthr threading library > http://threads.seas.gwu.edu/cgi-bin/man2web?program=libmap.conf§ion=5? > There's intent to make libthr the default for 7.0 and it may perform > worse in exactly this kind of benchmarks. You can run the benchmarks yourself, see: http://devloop.org.uk/documentation/database-performance/DIY/ It's as simple as running this from the top: ant -f test.xml junit.dbperf -Ddatabase=db-connection (but it won't generate the pretty graphics) I'll certainly put it on my todo list, but I can't guarantee when it will get done... - just looking at the todo list is on the list ;) Cheers Antoine PS: not subscribed to this list, so please CC me. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGONd5GK2zHPGK1rsRCuNnAJ9UT4YxcVtwUUkoEFC3FB8/VHyDeQCfclBq eDxd6K1nxBjakVVAOVi4kwI= =dQoJ -----END PGP SIGNATURE-----