Hi, > I am curious of the maturity and stability of page store.
I think it is stable now. Future versions will not be able to create databases in the old format (converting will still be supported). > changing from the old format to the > page store in the current latest versions since 1.2.127 and 1.2.128 > would cause any problems to the databases? It should not. The auto-conversion will also backup the database files by the way. > when a user's computer unexpectedly loses power, > the database tends to become corrupted. I ran an automated test for this case (using an old computer and a timer). So far I only tested some simple operations (org.h2.test.poweroff.TestRecover). My results so far are that databases can become corrupt in some cases with or without the page store. With recent versions (with page store; version 1.2.127 I believe) the risk was less than 1:20 (the test ran over the weekend without a corrupt database). Some time ago, I also tested other Java databases, and they did also become corrupt sometimes. I'm using a Linux kernel, I think the file system is ext2. My plan is to extend the test case (use different operations, indexes, larger rows). I'm not sure if it's possible to solve all problems, because in some cases it didn't look like a database problem. But I will try. 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.
