- 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.
Yeah but i guess in my case even if i have a create statement i would end up inserting the data a multiple times as I am copying the data from one table to another multiple times. So i think i would need a insert. Thank you regards Harish On Mon, Mar 26, 2012 at 3:24 PM, Thomas Mueller < [email protected]> wrote: > 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. > > -- Harish Mahadevan *Software Product Developer* * * *Knome Inc.* 25 First Street, Suite 107 Cambridge, MA 02141 USA [email protected] Phone: 617.715.1000 www.knome.com The Human Genome Interpretation Company This e-mail is covered by the Electronic Communications Privacy Act, 18 U.S.C. ยงยง 2510-2521 and is legally privileged. This email contains confidential information intended only for the person(s) to whom this e-mail message is addressed. If you have received this e-mail message in error, please notify the sender immediately by telephone at (617) 715-1000 or by electronic mail ([email protected]) and destroy the original message without making a copy. Thank you. -- 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.
