db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Kelder" <thomaskelde...@gmail.com>
Subject Re: Re: database in jar slower?
Date Sun, 03 Dec 2006 11:29:02 GMT
Thanks for your test results!
I've put my databases in jar files, ran some use case tests (contains
a lot of "SELECT x FROM y WHERE z = v" queries) and the database in
jar indeed seems to be faster:

In jar:
Hs_EGFR1_NetPath_4:        3218 ms
Hs_Fatty_Acid_Synthesis:    260 ms
Hs_iInsulin_Signalling:          2053 ms
Hs_MAPK_signalling:          1744 ms

In directory
Hs_EGFR1_NetPath_4:         4206 ms
Hs_Fatty_Acid_Synthesis:     361 ms
Hs_iInsulin_Signalling:           2455 ms
Hs_MAPK_signalling:            2176 ms


---------- Doorgestuurd bericht ----------
From: "Ryan Bobko" <ryan@ostrich-emulators.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Date: Thu, 30 Nov 2006 13:22:37 -0800
Subject: Re: database in jar slower?

I run derby from a CD. I haven't noticed a difference between using a
jar or using a directory, though I suspect the latency from the CD would
hide any.

So, I tried both ways from the HDD in a totally unscientific test
(select * from a table).

>From the jar:
real    0m1.699s
user    0m1.580s
sys     0m0.072s

>From the directory:
real    0m2.026s
user    0m1.704s
sys     0m0.092s

I repeated the test several times with consistent results. Anecdotally,
I'd say the jar is faster.


View raw message