Hi,
> > But Perfomance test in muiti-thread server mode > > achieved very good result in my environment. > I'm sorry but multi-thread server mode does not seem to work in read only environment. I tested as follows : 1. prepared 2 tables in two separated RDBMS. 2. created Linked Table for the 2 tables above. 3. then, excuted Query to H2 which join the 2 tables (left outer join) from multiple connection(thread) According to the RDBMS's log, the number of DB connections did not increase even though MULTI_THREADED was enabled. Instead, the number of processing queries decreased by 75%! Let me ask question : 1. I think MULTI_THREADED mode enables multiple concurrent DB connections to RDBMS which is referenced from LinkedTable. Am I right? 2. According to the Manual, OPTIMIZED_REUSE_RESULTS option is enabled by default. Does the OPTIMIZED_REUSE_RESULTS option decrease the number of queries which are executed from LinkedTable? Sincerely, On Oct 2, 5:24 am, "Thomas Mueller" <[EMAIL PROTECTED]> wrote: > Hi, > > >> jdbc:h2:~/test;PRIVATE=TRUE. Is this what you are looking for? > > But Perfomance test in muiti-thread server mode > > achieved very good result in my environment. > > > If multi-thread mode is stable(again, I just only use > > H2 Database for executing 'SELECT' statement which > > does not need synchronization), I think I do not need > > 'PRIVATE' option. > > That's true, when you don't update the table then the multi-threaded > mode should be unproblematic. In any case I will implement the > PRIVATE=TRUE in the next release. I need it to test the new > AUTO_SERVER and AUTO_RECONNECT features, and it turned out it's quite > easy to implement. > > 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 -~----------~----~----~----~------~----~------~--~---
