unixODBC
uses a strong thread-locking policy that causes big locks with the default configuration for FreeTDS™.
Performance of multi-threaded applications can be affected because every operation is serialized.
To avoid this problem, choose a threading model in odbcinst.ini
.
Example 5.4. Sample odbcinst.ini
for threading model
[FreeTDS] Driver = /usr/local/freetds/lib/libtdsodbc.so Threading = 1
Example 5.5. Sample odbc.ini
for threading model
[Server1] Driver = FreeTDS Server = myServer1 Port = 1433
You can use also a connection string e.g. DRIVER=FreeTDS;SERVER=myServer1;PORT=1433;
.