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 to the disk drive. While H2 has one database file, Apache Derby has one per Table or Index. Since the H2 file is growing to some GB of size, I would assume that this is the problem.
I will try to create a small java program as test case for you within the next days. Kind regards, Christoff Schmitz F I N A R I S Financial Software Partner GmbH Sömmerringstrasse 23 60322 Frankfurt am Main Fon: +49 (0)69 / 254 98 - 24 Mobile: +49 (0)176 / 206 34 186 Fax: +49 (0)69 / 254 98 - 50 eMail: mailto:christoff.schm...@finaris.de www: http://www.finaris.de und http://www.rapidrep.com From: Noel Grandin <noelgran...@gmail.com> To: h2-database@googlegroups.com Date: 25.03.2014 07:27 Subject: Re: [h2] Join slow on Windows XP, but fast on Windows 7 Sent by: h2-database@googlegroups.com 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, christoff.schm...@finaris.de 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout. ================================================================================================================ Disclaimer The information contained in this e - mail and any attachments ( together the "message") is intended for the addressee only and may contain confidential and/or privileged information. If you have received the message by mistake please delete it and notify the sender and do not copy or distribute it or disclose its contents to anyone. FINARIS Financial Software Partner GmbH, Sömmerringstr. 23, 60322 Frankfurt/Main, Germany Registered at Frankfurt/Main, HRB 52873, Managing Directors: Dipl. Inf. Hermann Friebel, Dipl. Ing. Kai Bächle, Dipl. Inf. Werner Märkl ================================================================================================================ -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.