Hi,
Thank for your advice. > 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. > Is there no synchronization even if Each "thread"(not "process") connect to embedded database? Sincerely, On Sep 30, 5:50 am, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
