Hi, Can anyone explain a bit more about this option - what it exactly achieves?
SET WRITE_DELAY regards Navjot Singh On Sep 6, 9:51 am, Navjot Singh <[email protected]> wrote: > 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.
