[unixODBC-support] Contention problem

Nick Gorham nick at lurcher.org
Sat Apr 8 08:10:36 BST 2017


On 08/04/17 03:28, Reza Taheri wrote:
>
> We do make a separate call to SQLAllocHandle(SQL_HANDLE_ENV, 
> SQL_NULL_HANDLE, &m_env);and also SQLAllocHandle(SQL_HANDLE_DBC, 
> m_env, &m_dbc);for every thread. FWIW, we always get 19289 for m_env, 
> and 19290 for m_dbc. This is even the case when I spread the threads 
> over 5 processes (and get 3X the throughput)
>
> I built with -enable-driver-conf=yes --enable-fastvalidate=yes. It got 
> maybe 10% faster.
>

May be worth trying without the driver manager, try linking directly to 
the driver.

-- 
Nick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20170408/7fb5c427/attachment-0001.html>


More information about the unixODBC-support mailing list