Hi Guys, Increasing the cache_size or even setting the cache_size to 0 works and limiting commits helps too i guess :-).
Thanks a lot guys. Really appreciate the help. regards Harish On Mon, Mar 26, 2012 at 6:23 PM, Harish Mahadevan <[email protected]>wrote: > - 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. > -- 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.
