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.

Reply via email to