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

[Frediano Ziglio]

Use a proper protocol version. For mssql you should use at least
protocol 7.0 which defaults to 4096 as packet size. Also newer version
optimize network packets sizes packing multiple TDS packets into network
packets.

-- 
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:
  New

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