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)? Thanks in advance and 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:[email protected] www: http://www.finaris.de und http://www.rapidrep.com ================================================================================================================ 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 [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.
