Hi Dario, I did run those tests on a desktop (2.3 GHz Quad core, 2 GB RAM, 300 GB HDD @7200). I got a 70s reading for 2 M records, so I guess it was the hardware.
Thanks again, Vin On Apr 12, 7:29 pm, Dario Fassi <[email protected]> wrote: > Hi Vin, > Let me say that with the mentioned hardware you are getting very good numbers: > > 2M records parsed and updated on DB in 176 secs. ~ 11364 tps > 10M records in 60 secs. ~ 167000 tps !!! > > With witch technology are you getting 167000 tps on a laptop ?? > > regards > Dario. > > El 11/04/11 15:05, Vin escribi : > > > > > > > > > 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.
