[h2] Is it safe and reasonable to open a read-only database in embedded mode from two processes without locking?

Is it possible, safe and reasonable to add ;FILE_LOCK=NO;ACCESS_MODE_DATA=r to 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

Re: [h2] Operator precedence

Hi. What do you mean by that? Is it available or should it be? If available, could you point me where to look at that page? Br, Timo On Friday, February 27, 2015 at 9:19:49 PM UTC+2, Thomas Mueller wrote: Hi, This should be available in the SQL grammar railroads:

Re: [h2] Is it safe and reasonable to open a read-only database in embedded mode from two processes without locking?

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

Re: [h2] Is it safe and reasonable to open a read-only database in embedded mode from two processes without locking?

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