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: http://h2database.com/html/performance.html#application_profiling Regards, Noel. On 2014-03-21 11:43, [email protected] wrote:
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 in about 15 minutes, but on another Windows XP (NTFS file system) machine it takes hours to complete. I watched the CPU usage of my application on both systems and I noticed that it uses one complete core during the whole time of the join on my Windows 7 Machine. On Windows XP, things seem to be different. Shortly after starting the join, the CPU usage behaves like on Windows 7. but after some time (The database has grown to approx. 2 GB on harddisk), the CPU usage reduces and oscillates at a quite low amount. I tested this on several Windows XP machines and the results always seem to be the same. Is there anything known about this problem (reason, workaround, fix)?
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
