Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problems with parallel insert into MS SQL server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with parallel insert into MS SQL server
  • Date: Tue, 10 Mar 2009 14:19:20 +0100

2009/3/10 Omri Bentov <omribentov AT gmail.com>:
> Hi,
>
> We are running a project that connects to MS SQL using multiple parallel
> ODBC connections (utilizing multiple threads). When we send the data from
> our server to the MS SQL server, we see that the data is received on a
> number of connections (i.e. when opening 5 connection from the server to the
> DB, we see 5 working connections), but only one connection is being utilized
> at the same time. When we tried to do the same test while running on windows
> (using the MS ODBC driver), we saw that more that one connection is utilized
> at the same time.
>
>
> Our set up specifications are:
> 1. Linux CentOS 5.2
> 2. FreeTDS-0.82-1
> 3. unixODBC-2.2.11-7.1
> 4. MS SQL Server 2008
>
>
> Do you have any ideas if the FreeTDS driver does any serialization on
> execute ?
>
> Is it possible to support such a configuration using a different
> configuration of the FreeTDS ?
>
> Best Regards,
>
> Omri Bentov

You are lucky. I just discovered some time ago that unixODBC by
default serialize drivers at environment level. To avoid this you have
to set Threading to 2 in odbcinst.ini. I should inform Nick too...

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page