[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

[h2] Updated AzureSQL connection URL

2017-07-13 Thread The bear in Boulder
I have an updated example AzureSQL connection URL in the recent patch. I was quoting documentation but this is based on an actual connection I use with the h2 console at work. I didn't realize that our code quietly adds all of these flags behind the scenes. jdbc:sqlserver://myserver.database.wi

[h2] Simple query very slow using ODBC postgre driver

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