Hi, I don't know how to further improve performance, but I would do profiling to find out where the bottleneck is (see the performance documentation).
Regards, Thomas Am 12.04.2011 08:37 schrieb "Vin" <[email protected]>: > Hi All, > > I am trying to evaluate the performance of H2 database for a project I > am working on. > > Database Mode - Disk based > Database URL - jdbc:h2:/directory/ > DatabaseName;LOG=0;CACHE_SIZE=65536;LOCK_MODE=0;UNDO_LOG=0 > > I have a small program that does the following > a) Creates TESTTABLE.csv with random values > > #COL1, COL2, COL3, COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, > COL12, COL13, COL14 > 62.2,39.2,56.3,110.6,77.8,94,86,63.9,64.6,95.3,68,702,3,2010-12-01 > 61.4,67.1,52.6,103.1,50,77.2,51,81.8,71.4,47.6,19.4,714,1,2010-12-01 > > b) DROP TABLE IF EXISTS TESTTABLE; > > c) sql = "CREATE TABLE TESTTABLE( COL1 DOUBLE, COL2 DOUBLE, COL3 > DOUBLE, COL4 DOUBLE, COL5 DOUBLE, COL6 DOUBLE, COL7 DOUBLE, COL8 > DOUBLE, COL9 DOUBLE, COL10 DOUBLE, COL11 DOUBLE, COL12 INT, COL13 INT, > COL14 TIMESTAMP)" + > "AS SELECT * FROM CSVREAD('TESTTABLE.csv','COL1, COL2, COL3, > COL4, COL5, COL6, COL7, COL8, COL9, COL10, COL11, COL12, COL13, > COL1','lineComment=#');"; > > For loading 2 M rows into the database - it takes around 176 seconds. > (Laptop Specs - 1.6 GHz Intel Pentium M, 2 GB RAM, 80 GB HDD @5400) > > Please can you suggest any tweaks/changes to the db that can help in > reducing the the time taken to perform the bulk insert. (Expect to > load upto 10M in one minute) > > Thanks, > Vin > > -- > 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. > -- 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.
