On 2013-08-12 15:26, Pierre wrote:
this last bench was Inserting 500000 t1 records and 3000000 t2 records
Also note that this benchmark is not really our strong suite.
If you want fast bulk insert then I recommend
- using PreparedStatement
- either using auto-generating primary keys for the data, or pre-sorting
the data and using our INSERT INTO XXXX DIRECT SORTED command, which
takes advantage of pre-sorted input data to speed up creating on-disk
data structures.
- using our options to turn off logging and locking, but making very
very sure that you turn them back on again afterwards.
But, me, personally, I'm happy to see that MySQL and HSQLDB are doing so
well - it's always great to have lots of good fast open-source databases.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
