Thank you Erin It's ok to split around 265,000 querys... but, I have to insert (total) 100,000,000 querys.
so.. is there more easy way? On Feb 16, 11:56 am, Erin Drummond <[email protected]> wrote: > Is it not an option to simply split up the script into multiple files > with around 265,000 querys in each? > > 2010/2/16 uyeee <[email protected]>: > > > > > Thank you Chuck > > > I download from here > >http://www.h2database.com/h2-2010-01-30.zip > > > I used "org.h2.tools.RunScript". > > > jvm option > > -Xms5120m -Xmx5120m > > > command line option > > -url "jdbc:h2:http:localhost/ > > test;SCHEMA=test;LOCK_MODE=0;LOG=0;UNDO_LOG=0" > > -driver "org.h2.Driver" > > -user sa > > -script test.sql > > > --------------------------------- > > test.sql > > insert into test (c1,c2,c3,c4,c5,c6) values > > ('a1','','b1','c1','d1','e1'); > > insert into test (c1,c2,c3,c4,c5,c6) values > > ('a2','','b2','c2','d2','e2'); > > insert into test (c1,c2,c3,c4,c5,c6) values > > ('a3','','b3','c3','d3','e3'); > > : > > : > > ---------------------------------- > > > but it stopped at 268,096 recode. > > > I see ,It caused by less memory. > > > Then, I should use more memory?? > > Or, I should use other tools?? > > > よろしくおねがいします! > > > -- > > 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 > > athttp://groups.google.com/group/h2-database?hl=en. -- 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.
