Hi, What version of H2 do you use? A bug related to large databases was fixed recently (see the change log, I think version 1.3.161). But I'm not sure this will fix the problem.
> Yeah i commit after every 100 million. Normally I would commit once every 1000 rows or so. 100 million sounds like way too much. > The job uses 1.4% of the 8gb. You should probably increase the cache size in H2 (cache_size). What kind of indexes to you use? For example, do you use an index on randomly distributed data? That would be a problem because it would it basically "kills the cache". Is there a file called <databaseName>.trace.db next to the database file? If yes what does it contain? Regards, Thomas -- 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.
