[freetds] FreeTDS slow with SQL Server 2014
ruslan.sivak at reis.com
Mon Jan 25 17:51:27 EST 2016
I have installed the latest from source and am experiencing the same
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.
On 1/25/2016 5:30 PM, Randy Syring wrote:
> Since 0.95 has been released:
> 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
>> recipient(s) named above and may contain information that is
>> 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
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
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.
More information about the FreeTDS