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" <[EMAIL PROTECTED]> 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
