Hi, > I want to use H2 database for Read Only Mode > using LinkedTable. > So, I tested performance of H2 > Server mode and found Multiple access (over 20) > delays the response time.
If the database files are read-only you could open the database in embedded mode. Each process would open its own database. That way there is no synchronization. The newest version can create temporary linked table, this may be useful if the database is read-only. Local temporary table can be created in read-only databases, however regular tables and regular linked tables not. > According to the manual, there is a command "SET MULTI_THREADED" > http://www.h2database.com/html/grammar.html#setmultithreaded > > It reads that "Currently, enabling this is experimental only.". > Can I enable it in "Read Only Mode" safely? Yes, that shouldn't be a problem (I didn't actually test it, but in theory nothing could go wrong). But using the embedded mode is even better. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. 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 -~----------~----~----~----~------~----~------~--~---
