Hi, > the Linode is in London and I am in the central United States.
It's not a common use case to have such a high latency between the database client and the server. Is it really required to run the server on another continent? > Is there a reason why connecting through JDBC would be so much slower than > with the web console? I guess OpenOffice runs many requests, so latency is the problem. Of course you could verify this if you run a profiler: See also http://www.h2database.com/html/performance.html#application_profiling > I was under the impression that H2 has a simple connection pool built > into it. Is there a way to configure H2 to use the built-in connection > pool when it hands out connections? Perhaps through the URL? No, the connection pool can't be used for what you want. You could force the database to stay open for a few seconds: http://www.h2database.com/html/grammar.html#set_db_close_delay - but I don't think this will help if latency is the problem. 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.
