Unanswered: OBDC Connection over WAN slow (regardless of data amount)
I'm talking to SQL Server via OBDC over a WAN. There appears to be a certain delay for each and every query that goes through the link - and the delay is not related to the amount of data being transfered.
I have tried running a query that results in 1 record, and a query that results in 1000 records. Both have a response time of almost 1 second - while both happen almost instantenously when run over the LAN.
Any suggestions on what I could look at to solve the problem?