Are you able to put together a simple example that shows the problem (script to create table, java app that connects to thhe database and does the inserting)?
The profiler output shows the problems of people having to ask you to do tests - all the results show is that the problem is within the execution of the insert, this is what you already know, so does not help. If you can provide a working example, people can take a look with whatever class level profiler the choose and maybe able to find out what is causing the results you see. There is a need for you to create the app as the problem could exist due to the way things are coded, or the data you are inserting and how H2 deals with it. If you provide a test app, you will know that it shows the problem and so others can be certain that they are working on an example that has the problem and all the settings that you operate under. Roger On Monday, April 7, 2014 11:35:57 AM UTC+1, kais haddadin wrote: > > Hello, > > I am inserting (with batch insert - bulk=10000) around 350,000 rows in a > table, when the table (and File DB) does not exist the load is very fast, > then I rerun the test which drop the table before (if exists) then commit > then recreate the table, the insertion then is very slow and there is a lot > of nearly idle CPU time. The connection is a simple connection, no > parameter are given. I added CACHE_SIZE=65536 but it didn't help. Can > somebody help me on this? I want to avoid to use most of the parameters > mentioned http://www.h2database.com/html/performance.html#fast_import since > it makes the database unstable. > > Regards, > > Kais > -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.