Hi, > rather big (> 2 Mo ...)
With 1Mo = 1MB, this is a few megabytes? That sounds relatively small... What I would do is add a feature to backup the database from time to time. Maybe I can help you with the details. I would try an automatic algorithm, keep the last few backups, and also test the backups; first use "backup to ..." so that the application is blocked only very shortly, then in a background thread open the backup and run "script to ...", this is to verify the backup was successful. You don't need an automatic restore feature, so no GUI changes are needed, but support would be much easier, and it might be possible to find out what the root cause is (network drive, hardware, software, if software where exactly). > At least some of the user have stored the DB on a network drive where they may have been concurrent access attempts. Yes, this can be a problem. For version 1.3.x, you could try file level locking by appending ";file_lock=fs" to the database URL. Version 1.4.x (I don't suggest to use that version for production) uses file locking by default. Also, the file format, and specially the recovery algorithm are much simpler. And there are a lot less write operations. So once it is stable, overall the risk of corruption should be smaller. What I would do is run some tests with version 1.4.184, to find out if everything works as expected, and once the MVStore is stable, use version 1.4.x. Regards, Thomas On Thu, Dec 18, 2014 at 1:02 PM, Noel Grandin <[email protected]> wrote: > > > > On 2014-12-18 09:52 AM, Marc Heinz wrote: > >> - Concurrent access attempts when stored on a network drive ? >> > > Probably that. Network drives are notorious for data corruption, > especially when concurrently accessing the same file. > I would do my best to detect that situation and prevent your users from > doing that. > > > -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
