ODBC Based SQL query appears to be "throttled"
Posted on 2004-08-28
I'm pulling my hair out on this one...
I keep a Delphi 7 development at a client's site. I have a SQL query tool that built in Delphi, using ODBC connection to Sybase and MS SQL. It has worked flawlessly for years.
Just recently it is acting very weird - a query run with this program on the D7 PC takes 40+ seconds (run against Sybase AND mssql, both slow). Run using the same tool on any other PC and the query takes about 1/3 of a second...
If I copy the tool from the "bad" PC to a network drive, and run the tool from the shared drive on any other PC it works great (so it isn't the code). I did a ghost of the D7 PC, and applied it to a second PC (100% same hardware) - it still goes slow - so evidently not NIC or hardware related.
One thing - I installed "skype" (internet phone software) about two weeks ago. I know skype throttles tcp/ip bandwidth usage for its own connections - maybe something bad went wrong there? I uninstalled skype (and dug into registry to find pieces it didn't uninstall). I also ran Norton WinDoctor and cleaned up some old registry anomalies.
It still runs slow...
I need some suggestions of what to look for next - I'm stumped.