freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.
-
[freetds] FreeTDS slow with SQL Server 2014,
Russ Sivak, 01/25/2016
-
Re: [freetds] FreeTDS slow with SQL Server 2014,
Randy Syring, 01/25/2016
-
Re: [freetds] FreeTDS slow with SQL Server 2014,
Russ Sivak, 01/25/2016
- Re: [freetds] FreeTDS slow with SQL Server 2014, Frediano Ziglio, 01/28/2016
-
Re: [freetds] FreeTDS slow with SQL Server 2014,
Russ Sivak, 01/25/2016
-
Re: [freetds] FreeTDS slow with SQL Server 2014,
Randy Syring, 01/25/2016
Archive powered by MHonArc 2.6.24.