[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    Re: [freetds] FreeTDS slow with SQL Server 2014
From:       Frediano Ziglio <freddy77 () gmail ! com>
Date:       2016-01-28 21:09:11
Message-ID: CAHt6W4efsUYV9DO5n4-PWMOaHK36h=zPDfqenUAR33DhfcUawA () mail ! gmail ! com
[Download RAW message or body]

Il 25/Gen/2016 23:40, "Russ Sivak" <ruslan.sivak@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-yedFEIILL8CzCUUSDssUOYevhd79IKyr \
yTg_otihDiEazYGsKrzYGsKrR5fndsvW_fCzBAsMCeWZOWqqaf8EKnvhhuWyaqRQRrIcYG7DR8OJMddECSjt-j \
LuZXTLuVKVI04X7_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@lists.ibiblio.org
> > > 
http://cp.mcafee.com/d/2DRPoArhovp7e8TvhdTdFT7ecL3DQhNJd5BBZV4QsT76QXzD6nxPW9EVdBQjsmW \
7X3GicWl1kvBjBPsvBjBPuEFWVHz_nVYQsIzC4NTnKnjjhhV55OXWabTkhjmKCHtxDBgY-F6lK1FJcSOrLOtXT \
LuZXTdTdw0PVkDjF4943VlU03wCHIcfBisEeRNSf_d2xJSf_d2xsxlK5LE2zVkDjF4943VlU02rvus76MnWhEwdbrIv-q53iWq81uf-2gUod453WC3h0oBcCq81w1MGq81zUCvyq84XEI6S1NLzCpc4V9ptLc

> > > 
> > > 
> > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS@lists.ibiblio.org
> > 
http://cp.mcafee.com/d/avndygw720wrhovp7e8TvhdTdFT7ecL3DQhNJd5BBZV4QsT76QXzD6nxPW9EVdB \
QjsmW7X3GicWl1kvBjBPsvBjBPuEFWVHz_nVYQsIzC4NTnKnjjhhV55OXWabTkhjmKCHtxDBgY-F6lK1FJASOr \
LOtXTLuZXTdTdw0PVkDjF4943VlU03wCHIcfBisEeRNSf_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@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


[prev in list] [next in list] [prev in thread] [next in thread]