Hi, Most of your questions are answered in the documentation already.
> My example revisited: > - Two transactions are committed (T1, T2) = they are written to transaction > log Are T1 and T2 independent transactions, or is T2 based on T1 (did T2 start after T1 ended)? If yes, H2 will either have T1, or T1 and T2, or none of them committed. But not "just T2". The transaction log of H2 is linear (append only), there is no "out of order" processing possible. This is how most transaction logs work, see also http://en.wikipedia.org/wiki/Transaction_log > What is currently the practical benefit of h2 cache? Performance. > Does it speed up operations if the other caches mentioned above are turned > off? It is faster no matter if the other caches are turned off or on. If you don't believe it try yourself. > Can I make h2 to fsync before returning from a commit if I set WRITE_DELAY to > 0? No. To do that, use CHECKPOINT SYNC. See also http://www.h2database.com/html/grammar.html#checkpoint_sync 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.
