[Bug 641612] Re: pyodbc + unixodbc + freetds slow

[Steve Langasek]

Per the upstream response (comment #2), I'm closing this as invalid
since it's a library configuration issue rather than a bug that needs to
be changed in the code.

** Changed in: freetds (Ubuntu)
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to freetds in Ubuntu.
https://bugs.launchpad.net/bugs/641612

Title:
  pyodbc + unixodbc + freetds slow

Status in freetds package in Ubuntu:
  Invalid

Bug description:
  
  I'm using pyodbc 2.1.8 (buitl this piece myself - I didn't see an Ubuntu package for it), unixodbc 2.2.11-21 and freetds 0.82-6build1 to talk to an MS SQL Server sytsem on Ubuntu Lucid.

  The performance isn't stellar.

  I noticed that many of the packets, while looking via wireshark, were
  short - just over 500 bytes.  There's a claim out there that
  increasing the packet length (I believe this is BLOCKSIZ in the
  freetds source, but I'm not certain) doesn't help, but I've seen that
  increasing packet lengths can help a lot with transfers on gigabit
  links, even though it may not make much difference on 10BaseT or even
  100BaseT - increasing the length keeps the CPU from becoming the
  binding constraint.

  Anyway, I have much more detail here:
  http://code.google.com/p/pyodbc/issues/detail?id=120&q=freetds

  It seems like making the freetds driver use a large block size should
  help, but if you have any other thoughts on how to make ODBC transfers
  with TDS faster, I'm all ears!

  Thanks for the great software!

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/freetds/+bug/641612/+subscriptions