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
Thomas
---------- 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.
ry
|