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: Omri Bentov <omribentov AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems with parallel insert into MS SQL server
  • Date: Wed, 11 Mar 2009 12:02:49 +0200

Thanks for the quick reply.

You are awesome.

Omri

On Tue, Mar 10, 2009 at 3:19 PM, Frediano Ziglio <freddy77 AT gmail.com> wrote:

> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page