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.
