Hi, It's hard to say, it would be best to analyze what the database engine is doing during that time using thread dumps. Usually it's enough to capture a few and then have a look at them.
Regards, Thomas On Friday, July 14, 2017, Murilo Mansano <[email protected]> wrote: > > I am having problems using H2 in server mode (org.h2.tools.Server) using > ODBC driver in VBA (Excel 2016). When trying to execute a simple select on > an empty table, the query takes about 2 seconds to execute. I've tried > almost all versions of the drivers, tried to change the version of java to > 64 bits, but the problem persists. When running the query on the same > machine that is running the H2 server the problem does not occur. I do not > know what I can do anymore, did anyone have such problems using ODBC driver? > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
