Firstly, are you sure that
(a) the machines have similar disk drives?
(b) the machines have similar CPU and memory specs?
(c) you are running the same version of Java and H2 on all the machines?
If all that is true, then you may need to do some profiling to help us identify
the problem area:
Hi,
a, b and c are true.
Additionally, I tested the same Join with the Apache Derby Database.
Apache Derby does not show that performance difference between Windows XP
and Windows 7 (same Test machines and JVMs used).
For me, the main difference between both databases is the way data is
stored
Hi,
I have the following problem.
My Application uses a H2 database (1.3.171) stored to the hardisk.
I am running a full outer join (implemented by RIGHT OUTER, UNION , LEFT
OUTER) between of 2 tables (30 columns each, 1.1 million records each).
On my Windows 7 Test machine, the join completes