[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [stellation-res] MySql
|
On Fri, Aug 16, 2002 at 10:00:12AM +0200, Martin Möbius wrote:
> I will try the same for firebird. Are there any generic benchmarks for
> databases using jdbc?
>
I don't know of any generic benchmarks, though I haven't looked at this.
However, here are some ideas based on some rudimentary testing I did a few
months back.
Here's a script I used playing with the Linux kernel source (2.4.9-12):
#!/bin/bash
L=linux
set -vx
svc add $L/net $L/include $L/scripts $L/mm $L/ipc $L/kernel $L/lib $L/init $L/fs; svc ci
LD=linux/drivers
svc add $LD/acorn $LD/acpi $LD/addon $LD/atm $LD/block $LD/bluetooth $LD/cdrom $LD/char $LD/crypto $LD/dio; svc ci
svc add $LD/fc4 $LD/hotplug $LD/i2c $LD/ide $LD/ieee1394 $LD/input $LD/isdn $LD/macintosh $LD/Makefile $LD/md $LD/media $LD/message $LD/misc $LD/mtd; svc ci
svc add $LD/net $LD/nubus $LD/parport $LD/pci $LD/pcmcia $LD/pnp $LD/s390 $LD/sbus $LD/.depend; svc ci
svc add $LD/scsi; svc ci
svc add $LD/sensors $LD/sgi $LD/sound $LD/tc $LD/telephony $LD/usb $LD/video $LD/zorro $LD/.depend \
$L/abi $L/arch $L/configs $L/COPYING $L/CREDITS $L/Documentation $L/Makefile $L/MAINTAINERS $L/README $L/REPORTING-BUGS $L/Rules.make; svc ci
I had to break up the checkin into several pieces due to running out of memory. Above took about 45 minutes
real time using PostgreSQL (as I recall), though as Mark has noted we currently do one JDBC round trip per line,
and the kernel source has about 2.5 million (distinct) lines.
I tried to run this using DB2, but I managed to fill up the log file, and as my DB2 knowledge is quite limited,
and the DB2 manuals quite large (hundreds of pages), I was unable to figure out how to fix this.
The kernel source is of course atypically large, but presents an extreme stress test.
I also played a bit with various versions of Jikes, which is maintained using CVS, by using CVS export to
generate a tar file, and then using 'sync' to import into a Stellation workspace, and thus creating a
Stellation repository. This could of course be done with any CVS-based project, though the scripts I used
are in a rough form and don't merit inclusion in this note.
dave
--
Dave Shields, IBM Research, shields@xxxxxxxxxxxxxx.
