Hi, > I tested as follows : > 1. prepared 2 tables in two separated RDBMS. > 2. created Linked Table for the 2 tables above.
So you have 3 databases? In what database(s) do you use the multi-threaded flag? > 1. I think MULTI_THREADED mode enables multiple concurrent > DB connections to RDBMS which is referenced from LinkedTable. > Am I right? No. The same linked table (actually the same connection) is never used concurrently. > 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? This option is not related to linked table. http://www.h2database.com/html/grammar.html#setoptimizereuseresults The database can't know if the data in the linked database was changed, so it always have to re-run the query. 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 -~----------~----~----~----~------~----~------~--~---
