NetBeans has a nice user-friendly profiler built into it (and it's free). Thomas Mueller wrote: > > 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] > <mailto:[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] > > <mailto:[email protected]>. > > To unsubscribe from this group, send email to > > [email protected] > <mailto:h2-database%[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.
-- 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.
