Using mvstore directly, is there a way to mark a map as readonly

29 views
Skip to first unread message

David Goodenough

unread,
Dec 20, 2022, 3:28:54 PM12/20/22
to H2 Database
I have a database which uses mvstore directly (no sql).  It has three maps in it, one of which is only ever loaded when I create the database.  I always close the database between writing this first table and subsequent runs when I am just reading the table. The other two tables are written and read.  

In all cases I do not need the data read from the database cached for re-read, as I convert the data read from the database into internal structures which I keep anyway.

Is there any way to tell mvstore that my first table is readonly after the first run, and will it help?

Also is there a way to tell mvstore not to bother caching read results, and again will it help?

Andrei Tokar

unread,
Dec 20, 2022, 6:51:05 PM12/20/22
to H2 Database
I think the answer is "no" on both points. Currently here is no API to declare particular map read-only, and there is no way to disable caching of data for particular map, since it cached at lower level. I wonder what benefits do you expect from that?
Reply all
Reply to author
Forward
0 new messages