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: Russ Sivak <ruslan.sivak AT reis.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS slow with SQL Server 2014
  • Date: Mon, 25 Jan 2016 17:51:27 -0500

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.

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.




Archive powered by MHonArc 2.6.24.

Top of Page