Re: What are the expected semantics for a read-only database with multiple processes?
Mark Raynsford via Hsqldb-user <[email protected]> Thu, 3 Nov 2022 17:14:20 +0000
| Newsgroups | gmane.comp.java.hsqldb.user |
|---|---|
| Organization | io7m.com |
| Message-ID | <[email protected]> |
On 2022-10-29T18:16:49 +0100 Fred Toussi via Hsqldb-user <[email protected]> wrote: > Please ignore my last reply as I didn't notice you are actually connecting via different processes. > > Your reader connection sees a read-only snapshot at the time it connected. For your purposes you need to shutdown the database after each process (reader or writer) does its work. If you use CACHED tables, or your MEMORY tables are very small, the open and shutdown shouldn't take too long. This is unlike SQLite. I see, thanks! We only use CACHED tables. Hopefully the overhead won't be too great. -- Mark Raynsford | https://www.io7m.com