PYTDS connection time out.

[fredkingham]

While working on the transfer history loader locally connecting to the server just hung and did not do anything.

We also had the issue of long running jobs just hanging. I experimented with adding a default connection time out on the pytds-timeout branch and the issue went away.

[takoau]

Is that a memory issue? The downside of pure Python TDS implementation is the overhead on data structure.

Could you also provide the data volume and how you move the data? Using bulk copy or simple insert?