Let me explain problem clearly. We are using Script to get the insert statements generated when our server goes down and we are loading the file using runscript when we restart the server. as we are expecting more than 100,000 records per table in the in-memory database, we are worried about the performance , when the records are loaded with runscript tool. In Runscript tool does each insert is considered as a transaction or the entire script is run as a transaction? does this doesn't affect performance when the table is loaded. I understood from source code that the Constants.IO_BUFFER_SIZE ( defined to 4k) defines how much record goes in an insert statement. Is there a way for loading the records into table faster in my usecase.
Thanks for your help Anupama On Wednesday, May 8, 2013 12:20:29 AM UTC-7, Noel Grandin wrote: > > There isn't a way to do that, but it wouldn't make any difference to the > performance anyway. > > You could try using CSVWRITE to export the data > http://h2database.com/html/functions.html#csvwrite > > > On 2013-05-07 22:26, Anupama Pullela wrote: > > Hi, > > > > I am using 'SCRIPT TABLE tablename' to bacup tables with very large > > data, and writing the result set into a file, > > when I see the file, the insert statements are batched as 20 records > > in an inset statements. how can I increase that number, for example > > 100 records in an insert statement? > > > > Thanks > > -- > > You received this message because you are subscribed to the Google > > Groups "H2 Database" group. > > To unsubscribe from this group and stop receiving emails from it, send > > an email to [email protected] <javascript:>. > > To post to this group, send email to > > [email protected]<javascript:>. > > > Visit this group at http://groups.google.com/group/h2-database?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
