Hello, What comes to mind as a possible problem is that the Base doesn't use a connection pool and the database connection is closed/opened several times.
Regards On Apr 21, 11:34 pm, Bruce Alspaugh <[email protected]> wrote: > I have H2 running successfully in a Linode VPS using the Tanuki Service > Wrappers to run it as a linux daemon process. I am able to connect > using the web console and the response time is quite good when I connect > that way even though the Linode is in London and I am in the central > United States. > > Then I tried connecting to the same database using OpenOffice Base. It > connects, but it is painfully slow. I am using release 1.3.154 on both > ends of the connection. Is there a reason why connecting through JDBC > would be so much slower than with the web console? Is there anything I > can do to speed up the JDBC connection? > > OpenOffice Base runs fine when I connect to H2 over a LAN at my office, > or even if I connect to my office from home using a cable modem at home > and at the office. > > Bruce -- 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.
