Hello, I have a database (approx. 2200 tables with 500 lines each, 50Mb) that need to be accessed by several threads (4 or 6 for example). There is a lot of calculations to do on this database and it takes about 15 hours, so it needs to be very fast.
I already tried read-only mode with multi threading (MULTI_THREADED=TRUE, ACCESS_MODE_DATA=r) as *threads only read the data* and write the result in an other database. But is there other ways to improve performances ? For example, I think there is no need to "lock" the database as it is read only (but maybe I misunderstood something here). Should I use FILE_LOCK=NO or LOCK_MODE=0 ? (actually using lock_mode=0 in the url throw an error n° 90133 CANNOT_CHANGE_SETTING_WHEN_OPEN). Is there any other way to improve reading performances for read only database ? I will also try to put this DB in-memory. But does this improvements also applies to in-memory DB ? Thank you for your advices. Guillaume -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/kWH6r0SZGW4J. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
