-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 24/05/13 08:09, Noel Grandin wrote: > You could try running a "CHECKPOINT SYNC" command from onPause(). > > At the very least, that would dramatically reduce the amount of > work that H2 has to do during recovery.
To improve durability I've been experimenting with WRITE_DELAY and CHECKPOINT SYNC, as recommended here: http://h2database.com/html/advanced.html#durability_problems Can you tell me whether it's useful to call CHECKPOINT SYNC after each commit if WRITE_DELAY is set to 0? Or conversely, is it useful to set WRITE_DELAY to 0 if I'm going to call CHECKPOINT SYNC after each commit? Thanks, Michael -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iQEcBAEBAgAGBQJRp6lBAAoJEBEET9GfxSfMK1oH/3EnIuZmGi8lKCcBNfKsI42X F48OuSgQc8UDkbj0Ez7VtH+zZccceBC5NR2XIWhFdW1O3RW69uOT/rmYDeFSaFt6 7cX041FKHgT7SUIcVYOy4r+k8ZACi9WZBYibskv4Q1g8l5cTPbQzDlCETpzxpn6b nEm3EUyhKWWKsul/pmHUbonRfME4B0oE6ULqBQX6qz8iATAL5VOWWyFxEhId+Zgi dEOI0bSX5JK/PjocTM3lOFUmKphTZ0Od4+Lrn+o7ZFmH5zVyOqw6FkUf8ew4vlUl ZGl3WsUPhhCLCcQRMfNCp4mjZFaas9g1kwdPb5XIkEiq7ZMUivHgIDNkRieLTGo= =zUsF -----END PGP SIGNATURE----- -- 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.
