Re: [h2] Query very slow over ODBC driver connection

2017-07-18 Thread Thomas Mueller Graf
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 wrote: > > I am having problems using H2 in ser

[h2] Query very slow over ODBC driver connection

2017-07-13 Thread Murilo Mansano
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