-----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.


Reply via email to