Hi, I read some posts on the 'slow insert performance' reported by others but couldnt seem to figure out an approach to improve on this. Just wanted to share my problem and pick some brains about how others solved their problem and may offer some tips.
In my use case, there is a ever running process which does some analytics and keep generating the output data. This output data we save in H2 (version 1.3.157). We are using mixed mode as we got 2 processes writing to same database. The database file is lying on the shared network drive but fast r/w otherwise. Cache is 64MB. We use connection pool and a db close delay of 5s and rest all is default. I have noticed that upto ~80k rows, the insert perf is fast, hardly touches a ms but then gradually becomes slow. After that, approximately every 5th insert operation (or one about every half a sec) seems to be taking on an avg of 300ms while others keep inserting in about a 1 ms or less time. So with my shallow knowledge of H2, it seems that inserts shall be okay, there is something else happening within H2 at regular interval which is causing this extra time. What could be the possible cause? Please help me understand this. Is there some file operation that H2 is doing which can cause them to be slow as I read about some sync() being slow. I have profiled our application which doesnt seem to be contributing to this behavior. regards Navjot Singh -- 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.
