[asterisk-dev] 1.4 and CDRs -- The Breaking Point

[Venefax]

It seems that Frediano Ziglio , from the Freetds team, solved the riddle.

"Please try changing /etc/odbcinst.ini with


[ODBC]
Trace           = No
TraceFile               = /tmp/sql.log

[FreeTDS]
Description             = FreeTDS unixODBC Driver
Driver          = /usr/lib/libtdsodbc.so
FileUsage               = 2
Threading=2


(Threading line added)"

Odbcinst.ini setting affect only unixODBC. To improve performance even more
I think it would be useful if asterisk would do some sort of parameter
binding instead of using strings... but this is another improve :)

The Threading setting affect unixODBC locking style. Default (3) use a
locking for single environment so every query get serialized. 2 use a
locking for every connection.

I am testing it in production and so far, so good.