Hi, I don't recommend to use this mode.
If all processed access the database in read-only mode, then it should work. But if there is one process that updates the database, then the reading processes might not work correctly, or not at all. And you can't really protect against this as far as I see. Regards, Thomas On Sun, Mar 1, 2015 at 2:54 AM, Ryan How <r...@bitworks.com.au> wrote: > My Email doesn't appear have come through.. sending again. > > Sounds like trouble there!. A would still be updating metadata, and if B > is reading from metadata then it might be in a corrupted state. That would > be my guess. Have no idea really. But I wouldn't do it if you were counting > it on it work consistently. Might work 99.9% of the time then do something > strange. I might be completely off though. > > > > On 1/03/2015 2:00 AM, Johann Petrak wrote: > > Thanks -- this is what I had been thinking, but I thought it would be > better to bring it up since > this option is not explicitly mentioned in the documentation. > > Another interesting situation is where two processes access the same > database, again in embedded > mode, and one of the processes updates just table A while the second > process just reads from table B. > Would it be safe for the second process to open the database in read-only > mode and without locking, while > the first process opens it r/w and creates a lock file and would they > interfere with each other? > > > On 28 February 2015 at 17:43, Ryan How <r...@bitworks.com.au> wrote: > >> I'll let someone more qualified give you a better answer. >> >> But, yes I can't see any reason why it wouldn't work (The same as if it >> was on a read only filesystem?) >> >> I find embedded mode has better performance, but it is more profound in >> lots of smaller queries. If it is larger less frequent queries there isn't >> as much difference. >> >> You might have to test your specific case if you are trying to squeeze >> every bit of performance possible. >> >> Not sure if the cache might be better with the server though. Otherwise >> each process will have it's own cache. >> >> On 28/02/2015 8:49 PM, Johann Petrak wrote: >> >> Is it possible, safe and reasonable to add >> >> ;FILE_LOCK=NO;ACCESS_MODE_DATA=rto the URL from two processes which use the >> same database in embedded mode? >> If yes, can I expect better performance from doing it that way than from >> using a local server? >> >> >> thanks >> johann >> -- >> 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 h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> 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 a topic in the >> Google Groups "H2 Database" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/h2-database/JtWn2CjvIp0/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > 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 h2-database+unsubscr...@googlegroups.com. > To post to this group, send email to h2-database@googlegroups.com. > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
