Hello, We are currently evaluating H2 to store large tables and encounter problems to import data (through ODBC or via a CSV file) : we have several tables of 1-2 million records, some of which having 100-200 columns. 1) I find the import very slow (something like 2-3000 records per second. With Oracle for example, we are more than 10 time quicker. 2) The import does not reach the end for large tables, because of OutOfMemory exceptions 3) When I split the import by packets of 100000 records, I often get a strange error telling that binding was not done properly, even though I do exactly teh same, with the same column definition and names...
I hope you will be able to help, because I chose to try H2 after reading your affirmation about its performances... Regards, Stéphane GRAZIANI -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
