Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS slow with SQL Server 2014

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] FreeTDS slow with SQL Server 2014
  • Date: Thu, 28 Jan 2016 21:09:11 +0000

Il 25/Gen/2016 23:40, "Russ Sivak" <ruslan.sivak AT reis.com> ha scritto:
>
> I have installed the latest from source and am experiencing the same
> slowness.
>
> While I can make the slowness go away by messing with the tds version in
> the config file using version 0.91, I can't seem to do the same in 0.95.
>
> At the higher TDS version, however, I am seeing weird behavior in 0.91
> in that varchar columns are showing up as length 255, even though they
> are longer in the database.
>

Usually 255 means you are using a wrong protocol version.

Are you seeing slow connection or slow queries?

Are you sure you don't have logging turned on?

Frediano

> The operation that we are testing is an insert using executemany with
> about 30k records.
>
> Russ
>
> On 1/25/2016 5:30 PM, Randy Syring wrote:
> > Since 0.95 has been released:
> >
> >
http://cp.mcafee.com/d/5fHCMUp3zqb3X8VN6XW9KVJeUVNBUs-yedFEIILL8CzCUUSDssUOYevhd79IKyryTg_otihDiEazYGsKrzYGsKrR5fndsvW_fCzBAsMCeWZOWqqaf8EKnvhhuWyaqRQRrIcYG7DR8OJMddECSjt-jLuZXTLuVKVI04X7_Cxjw0egYNjwsrtz_PgEn8lrxrW0E-l9QWh2h0-lu00CTTD1NI5-Aq83iSX7_CxgQKCy0nz_wAe63h1g-FwQg69j9Cy0o0saCy0o-9DUCy1eWb1Jwsrvn8x
> >
> >
> > I'm sure it would be helpful to know if you have the same problem with
> > the latest stable version.
> >
> > *Randy Syring*
> > Husband | Father | Redeemed Sinner
> >
> > /"For what does it profit a man to gain the whole world
> > and forfeit his soul?" (Mark 8:36 ESV)/
> >
> > On 01/25/2016 03:52 PM, Russ Sivak wrote:
> >> We have been using SQL Server 2008 and things have been good.
> >>
> >> Recently we have upgraded to SQL Server 2014 and things have become
VERY
> >> slow. We are using FreeTDS freetds-0.91-2.el6.x86_64, which is the
> >> latest from EPEL that for CentOS 6.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> This communication (including any attachments) is intended solely for
> >> the
> >> recipient(s) named above and may contain information that is
> >> confidential,
> >> privileged or legally protected. Any unauthorized use or
> >> dissemination of this
> >> communication is strictly prohibited. If you have received this
> >> communication in
> >> error, please immediately notify the sender by return e-mail message
> >> and delete
> >> all copies of the original communication. Thank you for your
> >> cooperation.
> >> _______________________________________________
> >> FreeTDS mailing list
> >> FreeTDS AT lists.ibiblio.org
> >>
http://cp.mcafee.com/d/2DRPoArhovp7e8TvhdTdFT7ecL3DQhNJd5BBZV4QsT76QXzD6nxPW9EVdBQjsmW7X3GicWl1kvBjBPsvBjBPuEFWVHz_nVYQsIzC4NTnKnjjhhV55OXWabTkhjmKCHtxDBgY-F6lK1FJcSOrLOtXTLuZXTdTdw0PVkDjF4943VlU03wCHIcfBisEeRNSf_d2xJSf_d2xsxlK5LE2zVkDjF4943VlU02rvus76MnWhEwdbrIv-q53iWq81uf-2gUod453WC3h0oBcCq81w1MGq81zUCvyq84XEI6S1NLzCpc4V9ptLc
> >>
> >>
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> >
http://cp.mcafee.com/d/avndygw720wrhovp7e8TvhdTdFT7ecL3DQhNJd5BBZV4QsT76QXzD6nxPW9EVdBQjsmW7X3GicWl1kvBjBPsvBjBPuEFWVHz_nVYQsIzC4NTnKnjjhhV55OXWabTkhjmKCHtxDBgY-F6lK1FJASOrLOtXTLuZXTdTdw0PVkDjF4943VlU03wCHIcfBisEeRNSf_d2xJSf_d2xsxlK5LE2zVkDjF4943VlU02rvus76MnWhEwdbrIv-q53iWq81uf-2gUod453WC3h0oBcCq81w1MGq81zUCvyq84XEI6S1NKRCGuV7G
> >
>
>
>
>
> This communication (including any attachments) is intended solely for the
> recipient(s) named above and may contain information that is confidential,
> privileged or legally protected. Any unauthorized use or dissemination of
this
> communication is strictly prohibited. If you have received this
communication in
> error, please immediately notify the sender by return e-mail message and
delete
> all copies of the original communication. Thank you for your cooperation.
> _______________________________________________
> 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