Hello, I just want to make sure I understand correctly what happens if I use in my connection URL something like WRITE_DELAY=30000.
On the h2 website I found the following explanation for this option: "Set the maximum delay between a commit and flushing the log, in milliseconds." >From that I understand that the sequence is the following 1. a commit containing the changes to the db is done 2. x milliseconds pass (x <= WRITE_DELAY value) 3. the log is flushed -> here I suppose the log is the transaction log. Is this correct? And what is actually the transaction log used for (since the data is already committed)? Is my understanding correct here? Am I missing something? Some colleagues of mine understood the WRITE_DELAY is an interval in which multiple transaction commits can be accumulated and when the WRITE_DELAY interval expires all the commits are executed in one batch. I think this is wrong. Hope someone can clarify this. Thank you very much! -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
