Speeding up MSSQL Queries

Informer connects to Microsoft SQL databases through a JDBC driver, which behaves differently from connecting natively (for example through SQL Server Management Studio). One difference is that queries with parameterized values can run slower, and Informer uses parameterized values for MSSQL queries by default.

To mitigate this, add the following connection property to the Datasource connection settings (see Creating a SQL Datasource):

sendStringParametersAsUnicode=false

When this property is false, string parameters are sent to the server in a non-Unicode format, which gives faster query performance in most scenarios. Note that this setting can omit some results that include non-standard characters. See Microsoft's Setting the connection properties for more detail.