Hi, > - Normally I would commit once every 1000 rows or so. 100 million > sounds like way too much.
I forgot about: if you use CREATE TABLE(...) AS SELECT ... then a commit every x number of rows isn't necessary. The reason is that in this case, it's not a 'real' transaction (with all the overhead usually required). But that's really just CREATE TABLE AS SELECT. It should be about twice as fast as separate CREATE TABLE and then INSERT INTO ... SELECT. Regards, Thomas -- 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.
