Hi,
I had a need to import a bulk lot of data that will both insert new data
and update existing data in several tables. I have this in a transaction
because I don't want any of it to go ahead if any errors occur. It has
been working great, but I recently tried importing quite a lot of data
and after the H2 cache filled up the inserts started going very slow. I
increased the cache size and the jvm max heap to 512MB and it went
blazingly quick.
I now have a larger lot of data to import and I don't want to increase
the cache size any higher. I noticed priority 1 in the roadmap is Issue
157: Support large inserts and updates (use the transaction log for
rollback). Is this what I need to wait for or are there some other
settings I can tweak?
The other alternative is to change the import process so I don't need to
do it all in one large transaction, but it would be easier if H2 can
handle it :).
Cheers,
Ryan
--
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.
